Hello,
Could someone suggest how I can populate a userform combobox with the visible worksheets names ?
thanks
tasos
Hello,
Could someone suggest how I can populate a userform combobox with the visible worksheets names ?
thanks
tasos
Hi,
Try this code (Change ComboBox1 to the name of your combo box):
You can put it in the Form_Activate event.Please Login or Register to view this content.
Regards.
Welcome to: http://www.exceldigest.com/myblog/
"Excel help for the rest of us"
that's great.
When the userform is activated the combobox is blank.
How can I make it to select the name of the first sheet by default?
thanks again
Here is a revised version to take care of the combo text:
Just replace the previous code with this one.Please Login or Register to view this content.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks