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").ob ject.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" wrote:

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.

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


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

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

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


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146111

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

"Souny" wrote:

jlcoop01,

You could use the code something like:

Select Case Activeworksheet.OLEObjects("NameOfTheDropDown").ob ject.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" wrote:

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.

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.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146111

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" wrote:


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.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146111

.

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.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146111