Select Worksheets with an ActiveX Combo Box Control using Excel VBA

This video demonstrates how to populate a combo box (drop down box) with worksheet names and select a worksheet using Excel VBA. Both an ActiveX Combo Box and Command Button are used in this example.

[joseliz]

Dr. Grande, thank you for sharing this video. i will reference it when i come across the need to use this during potential research.

[gaminxden]

Dr. Todd Grande, thanks a lot to your video... it really helped.

[holyshipman]

this works great although every time i click the button it duplicates the sheets
can you suggest some code to prevent it from duplicating existing sheets?

[anastasiakrainyk]

Hello Dr. Grande, Thank you for the video. I was wondering if i have a combobox in a user form and i have populated the combobox with sheet names, how do i get it to go to the sheet only when i click a 'Save and Continue" command button and exit the user form if i click on a "Cancel' Command button?

[liyode]

i have used ur above work its really help me to navigate easily in more then 100 sheets .i want to do some more work in it if you help me on this as i want to select sheet and enter some numbers on specific cell of selected sheet . pl help on this how can i add these number on selected sheet from combobox

[nayeembanu]

Thanks Todd, I tried and Im half way through, however my code for the ComboBox is not working fine, its not actually taking me to respective worksheets, while writing the code I did not get to write this "ws.Select ... I dint get Select option at all"

[ngashiineka]

Thanks very much.do i need to save the code as a macro enabled file?

[nilanjanjoshi]

How can I get dropdown list without the command button?

[floppy]

Select Worksheets with an ActiveX Combo Box Control using Excel c#, anyone know? please help me

[dragos]

when i close the excel file it doesn t save the code, only the buttons .
what should i do