You could always set the linked cell of the control, and read that value.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.