combobox to search any worksheet and display each data in a listbox.

I have a userform with 1 combobox(searches any worksheets).5 textboxes that send data to specific worksheet.Now I want to add a listbox that shows data of that worksheet selected from the combobox. I want to do this beacause I have 100+ worksheets.Any help please.

Hello,
In Your userform Activate Event put:

Please Login or Register  to view this content.

Under your Combobox Change event put something like this:

Please Login or Register  to view this content.

Regards.

Hi Again,
For multiple columns, I would prefer to use a Listview instead of a Listbox as suggested in the link below:
https://dl.dropboxusercontent.com/u/...669/Book2.xlsm

Regards.

Thank you so much for all of these. Kudos!.
But maybe we can add this setup in my Userform. And can we add a little changes (If possible). Can we change the combobox with a Textbox and a search button. Because i have 150 worksheets to find. Please find attached for your refence..Thanks again.

This is my Userform:

Userform.jpg

Hey there,
Here is a revised version of the file.
https://dl.dropboxusercontent.com/u/...669/Book2.xlsm

I believe you might need to add some restrictions to the Add button prior to append lines to the list like:

1. Checking Data Types of information being entered.
2. Checking mandatory information
3. Checking duplicates.

Regards.

Thank you so much XLRATOR. Its working very fine, But Why it's not clearing the field (TEXTBOXES) once I select other sheet from the combobox?

Ah, one more thing why Data is not adding in the worksheets. Its only adding in the Listview but when I check the data its not there, The first file (Book1) that you send is sending the data properly.

Thanks and sorry for bothering you.

1. That's because we had to ask Excel to do so

1. And I thought you had to participate a bit

Here is a revised version: https://dl.dropboxusercontent.com/u/...669/Book2.xlsm

Regards.

Yeah! Its all working Thank you so much.

Thanks for all the effort sir, Salute for you!

Till next time.

You are welcome sir,
Good luck.