Jim/Steve,

I created the drop-down box by the following steps: Data, Validation, Allow,
List, where I then put in 9 entries delimited by commas.

I had been using a few lines of code in this macro where I used the Userform
and its input to fill in the choices, but it would be easier to remember the
various choices if they existed in a list where I could click on one to
choose it. That's how I ended up creating the little drop-down list tied to
a single cell. Now, if I could somehow automate the running of the macro
based on highlighting a new choice in the drop-down list. Thanks, Brad

"STEVE BELL" wrote in message
news:TS2le.1103$m%3.212@trnddc02...
Brad,

Not sure what kind of drop-down you are using. But set up your macro
something like this:

Dim mcro as String
mcro = MyForm.Combobox1
' or '
mcro = MyForm.Listbox1
' or '
mcro = Sheets("MySheet").Range("A1").Text

Run mcro

--
rand451
"Brad" wrote in message
...
Could someone explain the easiest way for me to automatically activate an
existing macro based on clicking on, then selecting a choice from a
dropdown list? Thanks in advance for any advice! Cheers! Brad