I have a regular drop down control on a spreadsheet (i.e. NOT an ActiveX) and
I want to get the text that currently appears in the window. This is the type
of control that does not allow yI am sure it is much easier than I'm making
it out to be, but I can't seem to retrieve it. How is it done?

Thanks in advance.

Sorry, I got interrupted mid-stream, my OP should read:

I have a regular drop down control on a spreadsheet (i.e. NOT an ActiveX) and
I want to get the text that currently appears in the window (i.e. selected).
This is the type of control that does not allow you to edit the box itself,
only to select an item from the drop down. I am sure it is much easier than
I'm making
it out to be, but I can't seem to retrieve it. How is it done?

"quartz" wrote:

I have a regular drop down control on a spreadsheet (i.e. NOT an ActiveX) and
I want to get the text that currently appears in the window. This is the type
of control that does not allow yI am sure it is much easier than I'm making
it out to be, but I can't seem to retrieve it. How is it done?

Thanks in advance.

With Activesheet.Dropdowns("Drop Down 1")
itm = .List(.ListIndex)
End with
msgbox Itm

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
I have a regular drop down control on a spreadsheet (i.e. NOT an ActiveX)
and
I want to get the text that currently appears in the window. This is the
type
of control that does not allow yI am sure it is much easier than I'm
making
it out to be, but I can't seem to retrieve it. How is it done?

Thanks in advance.