Ways to expand search bar code? Thanks!!!

Hi Kamal,

You need to expand your search to multiple worksheets using the Worksheet INDEX.
In VBA WorkSheets.Count is how many sheets you have and instead of "Sheets("Sheet3")" you need to loop through all your sheets. Something like:

Please Login or Register  to view this content.

ALSO you need to have your code in a MODULE that isn't behind a sheet or the userform as this will allow it to scope each sheet correctly. You have you Sub as Private and this might mean it can't look outside of the sheet module it is behind.

http://www.cpearson.com/excel/Scope.aspx

You know that functionality is built into Excel?

Marvin, Marvin, Marvin -- where are your CODE tags?

@shg,

OK - code tags in place,,,

I hate sentences that start with "You Know" as much as I hate sentences that start with "Unfortunately"

What functionality are you speaking of that "is built into Excel"?

Note - as I get older it seems I know less and less. Is it there is much more to know or I'm loosing some of my marbles?

I confess to only glancing at the form, and not reading the OP's code (or yours) at all, but ...

If you do Find, set the Within dropdown to Workbook, and press Find All, you get a nice list of all the places the search value was found.

>> I hate sentences that start with "You Know"

The comment was directed to the OP, young Marvin

@shg

young Marvin

I may have a few years on ya, shg (dob in 47 is me)

Also - I don't use VBA Find often and will need to lookup the parms. I don't see "Within.Workbook" as one of the arguments to the VBA Find Method....

After searching more you meant to use the Home Tab - Find and Select Icon - Find .. Which shows the Find and Replace Dialog where I find the Within Workbook stuff.

shg - I see now where you were directing me...

I didn't know the "Find All" button list was capturable into VBA. Is it?

I didn't know the "Find All" button list was capturable into VBA. Is it?

It's not, and you also can't control the Sheet/Workbook selector. But my point was/is, why create a userform and write a bunch of code to do something that the UI already does just fine.

NOW I totally understand!! Thanks for clearing that up

I guess I just missed the OP's intent and that it is already built into the GoTo tool in Excel. (I'm still learning )