Edit : Find....not working between sheets #2

OK... I must admit I do not know how to use that code.  Where do I plac
it?  Thanks. Caroly

--
medicchi
-----------------------------------------------------------------------
medicchic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1467
View this thread: http://www.excelforum.com/showthread.php?threadid=26301

0
9/23/2004 10:59:00 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
307 Views

Similar Articles

[PageSpeed] 0

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Short course:
Open your workbook
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-R to view the project explorer
Find your workbook.
should look like:   VBAProject (yourfilename.xls)  

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.  

Now go back to excel and test it out--Tools|macro|macros...|Run
SearchAllSheets

===
And watch out for wordwrap in Jim's post.

Move "strSearchString & _ onto this line:
               returnValue = MsgBox("In " & ActiveSheet.Name & " Found  " &



medicchic wrote:
> 
> OK... I must admit I do not know how to use that code.  Where do I place
> it?  Thanks. Carolyn
> 
> --
> medicchic
> ------------------------------------------------------------------------
> medicchic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14676
> View this thread: http://www.excelforum.com/showthread.php?threadid=263016

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
9/24/2004 2:09:16 AM
Select the code I previously provided you:

starting with     Sub SearchAllSheets()
and down through    End Sub

then do a Control-Copy  (Ctl-C)

Switch to your workbook in excel (With your workbook open),
Hold down the Alt key and simultaneously press the F11 key
The VBE Window should suddenly appear;
The the tree structure window (Project explorer) is on the left-hand side.
In that window click (once) on the object VBAProject(yourbookname)
Then go to the menu and select Insert:  then select module;
Your cursor, at this point should be in the Code Window

At this point do a    Ctl-V  (or Paste)

Now the code is in the (standard) module.

Close the VBE Window.

Back at your first worksheet  (sheet1 or whatever name, say sheet1) now you
are ready to run the code (macro).

Simultaneously, hold down the Alt key and press F8 - this brings up the
Macro Dialog box; look for the macro named    SearchAllSheets, single-click
it(select-it)
and click the   Run button (on right-habd side of same box;

That should do it (each time you want or need to perform a search).

You can assign the Macro to an Icon on your  Toolbar if you like to speed up
the select and run process..

HTH








"medicchic" <medicchic.1d269y@excelforum-nospam.com> wrote in message
news:medicchic.1d269y@excelforum-nospam.com...
>
> OK... I must admit I do not know how to use that code.  Where do I place
> it?  Thanks. Carolyn
>
>
> -- 
> medicchic
> ------------------------------------------------------------------------
> medicchic's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14676
> View this thread: http://www.excelforum.com/showthread.php?threadid=263016
>


0
jmay (696)
9/24/2004 2:20:18 AM
Reply:

Similar Artilces:

Excel work done in Me
I did all my work on excel. I recently purchased a new computer that is using XP Home and, after downloading my work files, I cannot pull them up. What did I do wrong? Any help would be truly appreciated. Rick It sounds like you do not have Excel installed on your new computer. "Rick" <no1plantman@yahoo.com> wrote in message news:a93301c3ebdd$82fbb6a0$a501280a@phx.gbl... > I did all my work on excel. I recently purchased a new > computer that is using XP Home and, after downloading my > work files, I cannot pull them up. What did I do wrong? > Any help would be...

tracking service tags and work orders
Hi, Is it possible to customize MSRMS to track service tags of equipment and then track work orders associated with working on those products? I don't want to re-invent the wheel if someone has already figured this out. Thanks, Doug Morton Mountain POS JD has done some developments for this. I suggest you contact him (jdyoung@digitalretailer.com ). Regards Afshin Alikhani - afshin@retailrealm.co.uk Retail Realm = = = = = = = = = = "Doug - Mountain POS" <DougMountainPOS@discussions.microsoft.com> wrote in message news:B14D23C2-D447-4C2B-8804-3D80257EA2A7@microsoft...

search #2
Can someone tell me why when I do a search and just put in the name thats in the from catagory in the news groups it will not come up with anything. hope you can help steve Hi Steve, Let's start from the beginning because I don't know what you are actually doing. The following link will set you up to search the *Excel* newsgroups using Google Advanced Groups search http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100 into the author field you can enter something like one of the following stevem@luminet.net Tom Ogilvy My webpage to help with such thin...

Alt Tab not Working in Excel
Hey, hopefully someone can give me a hand here. Alt+Tab just stopped working to switch between sheets in excel. I DO have Tools>>Options>>View>>Windows in Taskbar checked. I do see multiple sheets in the windows taskbar so this isn't the problem. Additionally, I'm aware of Ctrl+Tab and Ctrl+F6 (and their reverse "shift" capabilities). I really need to be able to have the little window pop up (with Alt+Tab) to be able to select the correct file without going through them all like you have to with Ctrl+Tab. Additionally, switching between other windows works ...

"The Operation Failed" #2
This is the message I get when I try to open Outlook 2000. I'm running Win2K. I recently had a serious crash and my computer is still not stable. However, I AM able to run Outlook Express. I've had viruses, which are cleaned out. (Bliss, Hacktool.Sechole). And whenever I start up any of the Office programs, they go through the "installation" process as if they were never started before. It's as if the computer has no memory that they've already been installed. Any assistance would be greatly appreciated. Thank you. ...

my ftp app not work correctly on Vista
I wrote a simple ftp app for listing/downloading files from a directory on an FTP/web server. My app appears to install fine on XP and Vista machines, and it can communicate (list/download) with the FTP/web server no problem on the XP machines (Pro, HomeEdition). But on this Vista laptop my app wont connect to the FTP server (note: I did not try ftp.exe from the command line to rule out if it is the app - but I think the app is OK). An I.T. guy said that by default Vista network connections are set to disabled or something like that. However, I can view an aspx page on the same We...

User not accessed the system since last 2 months
Is there any script available to determine accounts that have not logged in for the past x months. Please provide us the link and and guide line how to use that ? Thanks ...

Unhandled Script Exception #2
Hi, We get the following error when trying to post a G/L batch: Unhandled Script Exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'AVDYN.dbo.glpCreatePostingActivity' We are using Dynamics 8-SP2 Thanks for your help, Marc R. - Avanti Computer Systems recreate or restore the glpCreatePostingActivity stored Procedure will solve the issue. "Marc R." wrote: > Hi, > We get the following error when trying to post a G/L > batch: > > Unhandled Script Exception: > [Microsoft][ODBC SQL Server Driver][SQL Server]Could...

inventory shows as net income under Equity on balance sheet
Im new to MS Money Small Business 2004. At setup, the input of inventory shows up as net income under Equity on my balance sheet. How can I un-do or re-do this? Thanks in advance ...

can I edit a picture to look faded?
I want to edit my picture to be faded so I can use it as background with text over it. "deborahm" <deborahm@discussions.microsoft.com> wrote in message news:4D93DD63-8553-447D-A0AC-44EE0E1BD9B3@microsoft.com... > I want to edit my picture to be faded so I can use it as background with > text > over it. In Publisher you can do it one of two ways. For both ways start by inserting the picture. Method 1, right click on picture and select Format Picture, click on picture tab, then click on the dropdown for Color under Image Control and select wash...

Condtional format with formula
I have this formula =IF(ISNA(VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)) =TRUE, "DONOR NOT VALID",VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)) on cell B17. When the user selects a value in A17 from the drop down, it goes to sheet 'Data-FSList' to retrieve a value. If the value is not there it comes back in field B17 'DONOR NOT VALID' However when A17 contains no value from the drop down and is blank I do not want 'DONOR NOT VALID' to show in cell B17. Is there a way to add to the formula above if A17 is blank then...

Delivery Status Notification (Delay) #2
Hi, I have Exchange 2003. There are some remote user (using POP3)got messages like below from postmaster when sending email: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. xxxx@xxx.com Internal user (useing corporate/workgroup mode in Outlook) has no problem. No problem from OWA. The remote POP3 user is submitting the message over an authenticated SMTP connection. We don't allow unauthenticated email to be routed through our se...

? do i create raffle result sheet
Hi you may give some more details. Also post your question as body of your message :-) -- Regards Frank Kabel Frankfurt, Germany "daff" <daff@discussions.microsoft.com> schrieb im Newsbeitrag news:F9C6C5AA-D559-48DB-8231-8DBEA63C5A7E@microsoft.com... > Peo This one's for you<g> Gord On Mon, 20 Dec 2004 09:01:04 -0800, "daff" <daff@discussions.microsoft.com> wrote: lol -- Regards Frank Kabel Frankfurt, Germany "Gord Dibben" <gorddibbATshawDOTca> schrieb im Newsbeitrag news:d74es0pofu129bgf47m4ma4lc6poviufbr@4ax.com....

Importing data #2
hi I would like to import data from the web and although this is quite simple in Excel 2003 the new data (that comes in upon refresh) replaces the old. I was wondering if there is a way to keep previous history of the data, make Excel fill in adjacent cells with the new data for example. Thanks for taking the time to read this George hi, if you are using Microsoft query, the answer would be no. The Micorsoft query becomes a named range in excel that is linked to the query. by desing it expands and contracts at refresh to accommidate new data. I think to accomplish what you want yo...

Controlling execution of a Sub Procedure -Part 2 :(
Question:Is there any way to only start a Worksheet_calculate procedure once the iterative sheet with which it is associated is FINISHED? How can you detect when it is finished? Details below In a previous post I was trying to run a lengthy calculation in a Sub Worksheet_calculate() procedure IF certain conditions on a spreadsheet were met. Of course I was developing this outside the ultimate workbook application. I resolved my stack overflow problem by writing out results to a sheet other than the one that had the Worksheet_calculate() procedure associated with it. THAT d...

Counting with 2 Conditions
I created a report and would like to get a count of records with two conditions. Here is what I entered: =Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA") This information is entered in an unbound text. I would like to get a total count where the terminate field (yes/not) is checked and the caseload meets a certain criteria. Thank you! TomP wrote: >I created a report and would like to get a count of records with two >conditions. Here is what I entered: > >=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA") > >This information is ent...

Exporting an editable file
I don't have Publisher Have a (luddite) client who has a two page .pub document and after a struggle, finally got it in pdf format, but the pdf does not allow copying any of the text although the security settings allow it. How do I tell her to export the text so that it can be included in an information document? Thanks, Beverly Howard Will copy and paste into Word do it for you? -- Don Vancouver, USA "Beverly Howard [Ms-MVP/MobileDev]" <BevNoSpamBevHoward.com> wrote in message news:uVIla2EoEHA.3792@TK2MSFTNGP11.phx.gbl... > I don't have Publisher > &...

crm token #2
some times i track an email in crm sent it to a customer- i got the customer repaly to the mail but i dont see the traking icon in the replay message and it seemed to be un tracked but if i go to the customer history i see his replay inside the history further more if i press track in crm to his replay he'll give me directly the regarding field filled with this customer have some body an idia about this see this http://support.microsoft.com/kb/929385/en-us try to install rollup update 2 and it will work. -- Regards, Imran MS CRM Certified Professional http://microsoftcrm3.blo...

Data Labels on Clustered Column w/ 3D Visual effect #2
Clustered Columns can have Alignment as "Inside End" This doesn't seem possible with 3D Visual effect Is there a way to resolve this? Yes, use 2D charts. They provide a better representation of the values being plotted without the implied false third dimension. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ emwashburn wrote: > Clustered Columns can have Alignment as "Inside End" > > This doesn't seem possible with 3D Visual effect > > Is there a way to ...

Find function in a macro
I want to set up a macro that searches a column for a value 'X' and then selects the cell right under the cell that contains 'X'. I have been stumped on this for a few days now and would really really appreciate any sort of help or guidance. Thanks a lot! SK --- Message posted from http://www.ExcelForum.com/ Sub Findit() Dim r as Range For Each r in Range("A1:A1000") 'Or whatever yours is If r.Value = "X" Then Range("A" & r.Row+1).Select 'Change A to your column Exit For End If Next End Sub K P.S. You could probably use an...

Outlook 2000 Calendar Find won't work
When I try to use the "Find" command in Outlook 2000 Calendar I get a quick list of results then the screen clears to the "no items found" message. The "Find" command works in all other personal folders. Any idea what the problem is? ...

XML Insert data C# ASP.net 2.0 Need to know how to insert by speci
Hello, I have the following XML Schema: <?xml version="1.0" encoding="utf-8"?> <Schedule> <Day Name="Monday"> </Day> <Day Name="Tuesday"> </Day> <Day Name="Wednesday"> </Day> <Day Name="Thursday"> </Day> <Day Name="Friday"> </Day> <Day Name="Saturday"> </Day> <Day Name="Sunday"> </Day> </Schedule> I want users to be able to input the following tiomeblocks for a scheduling s...

Copying to new sheet
Hi, I have 12 WORKBOOKS (not worksheet) all the same and you can mak entires into them of stock. I also have a master workbook - exactly the same as the 12 others. Is there a way of copying whatever someone enters into any one of th 12 into the master one automaticaly? for example, i enter something into book 1 and book 6 and then i loo at the master one and it's been updates for me with those entrie aswell. many thanks, Simon. :confused -- Message posted from http://www.ExcelForum.com If you have linked the master workbook to the others with formulas thi should automatically oc...

Convert C:\1\2.exe to c:\1\ shlwapi
Looking a function to do that. shlwapi.lib Maybe someone else here will understand this, but it looks like a typo to me. You want to convert: C:\1\2.exe to C:\1\shlwapi (what?) Is this shortname to long name? I guess what I'm asking is what does 2.exe have to do with SHLWAPI? Tom "roxioxoto" <coco002@gmail.com> wrote in message news:1154971834.120105.234410@i42g2000cwa.googlegroups.com... > Looking a function to do that. > shlwapi.lib > Sorry :) Im just trying to get c:\1\2\ or c:\1\2 >From this path c:\1\2\filename.ordir using SHLWAPI lib or s...

Documentation about CRM 1.2 db structure
Does exist any documentation about CRM 1.2 modules and related underlying SQL tables? Does exist any documentation about mapping between CRM 1.2 SQL tables and CRM 3.0 SQL tables? Many thanks If you install data migration tool, there are some excel spreadsheet contains the fields for the given entity. I don't know if that's what you are looking for. In terms of the SQL table, CRM 1.2 and CRM 3.0 is similar. All the custom attribute will be in the extension table. E.g. AccountBase, AccountExtension. Hope this helps. Darren Liu Crowe Chizek and Company http://www.crowecrm.com On ...