Want to combine 8 separate form control to a combo box

Hello,
I am using Excel 2010 and I have 8 separate form control each with its own macro. I would like to create a combo box with a drop down with a list of each form control and be able to perform the same function as the individual form control when a specific name is chosen in the list of the combo box.

Thanks in advance

I tried this code but the worksheet keeps closing on me.

Please Login or Register  to view this content.

Each entry under each Case are macros recorded in VBA.

Please let me know what I am doing wrong.

Thanks

Bump - any help on this?

Attached is the file I would like to have a combobox to be able to do what the 3 form control could do in the form of a list format.

Hope this helps

Thanks

Originally Posted by davesexcel

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thanks Dave for your reply! I have uploaded a sample of what I am needing. In the Region tab, i would like for the combobox to have each choice to do what the "Select Region" form control does. Each of the data tabs consist of data that i would like to have entered into each cells when a specific region is chosen. I have a combobox already placed in the region worksheet but that is as far as I able to do.

Thanks

Hi

How about

Please Login or Register  to view this content.

rylo

Originally Posted by rylo

Hi

How about

Please Login or Register  to view this content.

rylo

Wow, I tried all types of ways to no avail and all i had to do to run the macros was to use Application.run!!! Thank you sooo much! Is there a way I could have some kind of message that would say "Select a Region" inside of the combobox? In other words some sort of reset or something?

Otherwise thank so much for your help as it works great!!!

Hi

After the end select try putting in something like

Please Login or Register  to view this content.

Didn't test that, but it should work.

rylo

Originally Posted by rylo

Hi

After the end select try putting in something like

Please Login or Register  to view this content.

Didn't test that, but it should work.

rylo

Rylo you are awesome! Thanks so much for your help!!! It works for what i need it to do!