Listbox search for sheet

[yabbadabba]

Hi guys,
I have a userform with 2 listboxes,1 textbox and one comand button. The first listbox has a list of sheet names in it (sheets are hidden). The 2nd listbox has list items in it.
What i am trying to workout is, i wanting the user to do is to make a selection from the first listbox (list of sheetnames), and a selection from the 2nd list box(items) and when the comand button is used it will search the sheet for the item and return the data in the textbox.
I hope someone can help me i've been racking my brain on this one for a while now.
cheers,
Mark

 

[Andrew Poulsom]

Return what data in the TextBox? Have a look at the Find method in VBA Help.

 

[yabbadabba]

Hi Andrew,
I will have a code that will search the sheet for the data, basically all i need help with is using the listbox to find and select the sheet.

 

[Andrew Poulsom]

To return the worksheet you can use ActiveWorkbook.Worksheets(ListBox1.Value).

 

[yabbadabba]

Thank you