Assign the dropdown macro to

Msgbox ActiveSheet.DropDowns("Drop Down 1").Value

will work as long as the value is changed by clicking the dropdown, not by
changing the linked cell that changes the value in the control.


"Larry Dodd" wrote in message
...
I have an excel spreadsheet that is using the Forms Dropdown box and it
gets
its data from a range of cells. I would like to know how to capture the
value of the text when it changes to something else. I would like to use
VBA
to do this. I know if I used the Controls dropdown box that would be
easier
but this is how this one is.

If there is no way that I can do that can someone tell me how to set the
Controls Dropdown to accomplish the same thing the form control is doing.