run multiple macros from a drop down menu

  • Thread starter Thread starter jlcoop01
  • Start date Start date
J

jlcoop01

I am creating an invoice type template and have address macros of the
locations we consistently service. I am needing assistance in getting them
to run from a drop down box. Any help you can offer will be greatly
appreciated.
 
jlcoop01,

You could use the code something like:

Select Case Activeworksheet.OLEObjects("NameOfTheDropDown").object.value
Case "FirstValuefromDropDown"
'execute the following code
Case "SecondValuefromDropDown"
'execute the following code
Case "ThirdValuefromDropDown"
'execute the following code
End Select

I hope that helps.
 
Souny,

Thank you for your response. I have tried this code with no luck. Does it
make a difference that the address macros are in my personal macros workbook?

Jodie
 
Joel,

Do you have any suggestions? I have the macro for the invoice working fine.
I was trying to make it easier to insert the location information where work
was performed. Thanks for your help!

Jodie
 
Back
Top