$$Excel-Macros$$ Re: How do I create a drop down list to select which macro to run

Hi Rolf, Futher to this post, a couple of quick questions: 1. How do I assign the form to a ctrl+key so that when the user wants to select a macro to run on the form that is the first thing that pops up? 2. How do I call a form from a macro in a module? This way if I want to get input from a

$$Excel-Macros$$ Re: How do I create a drop down list to select which macro to run

Hi Rolf, Thanks for the help with this. I will play around with it and hopefully get it to work. Am I right in saying that the value in ListBox1.AddItem ("Macro1") is Macro1, and it will automatically know which sub to use in the regular module? If I have 3 Modules, how can I indicate that th

$$Excel-Macros$$ How do I create a drop down list to select which macro to run

I have 3 different macros that work, and as opposed to giving them each their own ctrl+ key combinations to run, I'd like to create a kind of drop down msgbox or something like that that would list the different options available to the user so that they can select the appropriate macro to run. I

$$Excel-Macros$$ Cutting duplicate rows to a new workbook and saving with a new name

Hello, I've searched, but have been unable to find / figure out how to solve my problem. Any help would be greatly appreciated! Each week I receive a new list and I need to break it up into several sub lists. The problem then comes that I need to sort the sub lists by an email field (not a pro