Dropdowns

  • Thread starter Thread starter Terry von Gease
  • Start date Start date
T

Terry von Gease

Having discovered a reference and an example of dropdowns, a feature
apparently undocumented in recent editions of Excel, does there exist a
complete definition of this feature? The example only showed limited usage,
sufficient to infer how to use a dropdown but not a complete exposition of
the available features.

Specifically, is there a way to programmatically display the dropdown list.
Some way other than having to rely on the user to mouse-click it open?

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley
 
Terry,

Post back with a little more information on your 'dropdowns'
Are they:
Validation dropdowns
Comboboxes or Listboxes on the sheet
if so - are they Forms or Control Toolbox
On a Userform

I recently had Control Toolboxes on a worksheet and was graciously
given code that would display the dropdown when the cell was selected
(either with a mouse click and entered in any way).

Post back and if you need this code - I'll post it...
 
In the object browse, right click in a blank area and select show hidden.

You will see all the properties and methods for the dropdown object.
(Forms toolbar "combobox")


If you want a word document that provides some information on these
controls, let me know.

But to the best of my knowledge, there is no method for this control that
does what you describe. (maybe sendkeys)
 
Tom Ogilvy said:
In the object browse, right click in a blank area and select show hidden.

You will see all the properties and methods for the dropdown object.
(Forms toolbar "combobox")
Click to expand...

Ah...But why are they hidden? Are they some sort of embarassemt or are the
Great White Fathers at Microsoft slowly phasing them out?
If you want a word document that provides some information on these
controls, let me know.
Click to expand...

If you would be so kind that would be a boon.
But to the best of my knowledge, there is no method for this control that
does what you describe. (maybe sendkeys)
Click to expand...

Thought about that, but what key would one send? As far as I can tell a
mouse click on the drop down arrow is the only way to expose the list, there
doesn't seem to be any other sequence of keystrokes that will do this. That
being the case, if I understand all of the nuances of SendKeys, which is not
all that comprehensive on my part, there seems to be no way to send a mouse
click.

It's not a big deal, but it would make this particular situation more
civilized.

Thanks as always...

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley
 
Back
Top