Combo Box Macro?

[ShannonLarson]

Hello. I need a macro to accomplish 2 things with a combo box on a user form.

Populate the items of the combo box with the sheet titles of an excel file (for the purpose, I have a file with 53 sheets).

Then, once a selection is made in the combo box, open the selected sheet as the active sheet.

How do I code this? If someone would be kind to a new user and give me an example code, I would be very thankful.

[mikerickson]

in a normal code module

Please Login or Register  to view this content.

In the Userform code module

Please Login or Register  to view this content.

[ShannonLarson]

Thank you very much!