userform to search multiple worksheets

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

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...

Option Explicit

Private Sub FindDataOnDifferentSheets()
Dim WS1 As Worksheet, WS2 As Worksheet

Set WS1 = ThisWorkbook.Sheets("Sheet1")
Set WS2 = ThisWorkbook.Sheets("Sheet2")

Debug.Print WS1.Range("A:A").Find(100).Address
Debug.Print WS2.Range("A:A").Find(200).Address

Set WS1 = Nothing
Set WS2 = Nothing
End Sub

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

Cheers

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...

cmb1.additem  WS1.Range("A:A").Find(100).Address

You obviously change what is being populated into cmb1 however.

Hope this helps?

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

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

Can you upload your code or an example workbook?