userform to search multiple worksheets

**cfinch100** · 01-02-2013, 04:43 PM

hi
how would i go about searching for data in 2 worksheets , i have a userform that collecta data from sheet1 it has text boxes these work,it also has a combobox
that populates from same sheet , i need to populate another combobox from a different sheet4 , how do i initialise both worksheets please
ws=sheet1(mfr_list") & ws=sheet4("sheet1") do these 2 commands go at the top or where please
cheers colin

**JayHam** · 01-02-2013, 05:05 PM

Hi Colin,

Are you trying to reference a number of different worksheets

If I've read your post correctly you'll be after something like...

Please Login or Register  to view this content.

If this isn't what your after let me know and with a bit more information I may be able to help?

Cheers

**cfinch100** · 01-02-2013, 05:41 PM

hi
looks something like, what is the print part of it, i have a userform with 2 comboboxes1 and 2, cmb1 looks up sheet and cmb2 looks up sheet4 and populates userform than i send it all to sheet 3 , the comboboxes just give me choice selections while textboxes are populated by choices,
hope that explains will try out your suggestion in few mins
cheers colin

**JayHam** · 01-02-2013, 05:53 PM

The debug.print is just a way to return a result to the immediate window (CTRL+G to view).

You should be able to use the above code to link to your combobox...

Please Login or Register  to view this content.

You obviously change what is being populated into cmb1 however.

Hope this helps?

**cfinch100** · 01-02-2013, 05:56 PM

hi
will try to enter this morrow and let you know morrow nite just got called out to work
many thanks
cheers colin

**cfinch100** · 01-03-2013, 07:02 AM

hi
have tried this and can not get it to work could be putting it in wrong place
cheers colin

**JayHam** · 01-03-2013, 07:06 AM

Can you upload your code or an example workbook?

**cfinch100** · 01-03-2013, 08:42 AM

hi
workbook here its userform 1 thats the problem crane size looks up sheet "prices" its the driver combo that should look up "sheet1"
think im getting me self in a mess as usual
cheers colin