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.