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.

 

[joel]

A drop down box will move the selected range away from the cell you hav
selected. there are a few options to try


1) Add a control button on the worksheet. Select the macro you want t
run from the droop down box. Then select the cell you want to use an
push the control button

2) Add an Inputbox to you code to select the cell location during th
execution of the macro.

3) Use a Listbox instead of the dropdown box to select the macro

 

[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

 

[joel]

If you are using event macros then they have to be in the workbook that
is producing the event, not in the personal workbook. If the macro
isn't an event macro then you have to make sure your macros don't move
the fouc from the active sheet for this code to work.

 

[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

 

[joel]

there isn't enough information here to answer your question. Remmber we
have never seen you workbook and cannot read your mind. You are asking
a perfrect strange a question and must provide enough details to give a
great answer.