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.