Let's assume that your 3 macros are located in a standard VBA module
and look like this:
Sub Macro1()
MsgBox ("Macro1")
End Sub
Sub Macro2()
MsgBox ("Macro2")
End Sub
Sub Macro3()
MsgBox ("Macro3")
End Sub
Now insert a UserForm in your VBA project then drop a ListBox (named
ListBox1) onto it. In the code section for this UserForm enter the
following code:
Private Sub ListBox1_Click()
Run (ListBox1.Value)
End Sub
Private Sub UserForm_Initialize()
ListBox1.AddItem ("Macro1")
ListBox1.AddItem ("Macro2")
ListBox1.AddItem ("Macro3")
End Sub
Hope this helped,
Rolf
On Oct 30, 11:24 am, CPGH <ch...@vvsii.com> wrote:
> 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'm assuming it needs some kind of listbox or combobox, but I have no
> idea how to do this.
>
> Any help would be greatly appreciated.
>
> Thanks,
> Chris
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
