how to make a drop-down of all the macros?

[kjy1989]

Hi i'm having this problem i've tried tinkering with the vba buttons but i cant seem to find out how to do this. So i have a sheet that has different macros depending on the customer's product type. Let's say you have product1 you click the macro and the whole sheet changes. At first i did separate buttons but when it got to around product6, product8 my sheet is starting to become cluttered. How do you do it that there's just one dropdown box that when you click, all the macros will be there? I apologize since i am a beginner in VBA.

[kjy1989]

bump, i hope someone answers i really need help,..

[jraj1106]

Hi.

Post a sample file.

[kjy1989]

Hi, thanks for your reply.

Here is an example: burger taco hotdog.xlsm

So in this example you will click the macro that you want, whether it's a taco, burger, or a hotdog and clicking each will give a specific set of list that the customer has to fill out. So instead of putting out individual buttons for HOTDOG, TACO, AND BURGER, i would want to have just one drop down box that will contain all three. How is that done?

[kvsrinivasamurthy]

Pl See the attached file.

[kjy1989]

Wow that works great thanks!

I have a question though, i understood the worksheet_change event that you made the target the J4 cell but how did you make that cell into a drop down list? I am trying to find out right now but i am having a hard time. I really am a VBA beginner here and i appreciate your help!



edit* did some research and managed to make it work. Thank you sir!

[kvsrinivasamurthy]

Thanks.
Pl mark the thread SOLVED.