UserForm Search Specific Sheet based on ComboBox

[jimmisavage]

Hi all,
I have created a UserForm to search my workbook.

My UserForm is set up as follows:

(Label) Study: (ComboBoxstudy) A pre-defined list
(Label) Name: (Textname1) This is the user search criteria
Followed by a command button named search

The ComboBoxstudy options are also the names on my sheets.
So when someone chooses, lets say, 'annexa4' from the combobox and types 'dave' in the textbox I would like the search to search of dave (or Dave) in the sheet called annexa4. I would like the userform to remain open so the user can click search again to find the next dave... and so on. (dave will only appear in either column A or B of the sheet).

I have this code but it only searches my current sheet because i don't know how to include the combobox:

Please Login or Register  to view this content.

I'm probably way off my goal here so if anyone can help, i would really appreciate it.

Kind regards
Stuart

[LeoTaxi]

Change With Cells to With Sheets(ComboBox1)


Kind regards
Leo

[jimmisavage]

Hi Leo,
That pulls an error for me.

I found this other code that does search the correct sheet but how would i add a loop to search for the next instance if the first instance isn't the one i'm looking for?

Please Login or Register  to view this content.

[LeoTaxi]

maybe post youre file, and someone
will do for you, me back in 10 hours

Cheers
Leo