OnAction & Drop Down List
If the dropdown you speak of is produced by data validation, you the
Worksheet_change event in versions later than xl97.
Otherwise, you if from the forms toolbar, then assign a macro to it, or for
a combobox from the control toolbox toolbar, use the click event.
--
Regards,
Tom Ogilvy
"MariaG" wrote in message
...
I have a drop down list in a cell on the worksheet. Once
User makes a selection from the drop down list, I would
like Excel to run a Macro based on the Item Selected or at
least to know that the User has made a change to the drop
down list.
Can anyone help me with this code?
Thanks in advance.
MariaG
|