run multiple macros from a drop down menu

[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.

 

[Souny]

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.

 

[jlcoop01]

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

 

[jlcoop01]

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