The Forms dropdown returns its listindex (1-based) into the linked cell, not
its text. So this requires either an INDEX formula in a helper cell or a VBA
macro assigned to the dropdown:

Sub DropClick()
ActiveSheet.Range("B2").Value = _
ActiveSheet.DropDowns(1).List(ActiveSheet.DropDown s(1).Value)
End Sub

HTH. Best wishes Harald

"Bob Phillips" skrev i melding
...
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.