I know about the Show Hidden Members, but all it does is list the critters.
For example, there's no info about DropDowns.

I'll have to see whether Excel 7 has any such info, ..., OK, just looked,
Excel 7 has description of DropDowns, etc..
Alas, I wish I had an Excel 7 VBA book.
Hmmm, perhaps, I can copy the Excel 7 VBA Help file?
Ayup, VBA_XL.HLP does the deed.
--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------
"Dave Peterson" wrote in message
...
Try using the namebox to the left of the formulabar (with the dropdown
selected).

You can see the hidden elements in the object browser, too.

Back to the VBE. Hit F2 (to start the object browser)
Then rightclick in the object brower and check "show hidden members"
Then search for dropdown and you'll see lots of neat stuff.


Howard Kaikow wrote:

I tried using Insert |Names.
All I could do was add a name.
The control name was not changed.

--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------
"Chip Pearson" wrote in message
...
Howard,

You can manually change the name by selecting the control
(right-click) and entering the name in the Name box, the same
place you type in range names.

In VBA, use something like
ActiveSheet.DropDowns(1).Name = "TheNewName"



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Howard Kaikow" wrote in message
...
When I right click on an ActiveX control in a worksheet, I have
an
opportunity to set and learn the control's properties, including
changing
the control's name.

How do I do that for the old controls from the Forms toolbar?
In particular, how do I learn/set the control's name?

I know how to do this within the code, e.g.:

ActiveSheet.DropDown(1).name = "PizzaMenu"

But cannot seem to find the control property, for a Forms
control, via the
GUI.
--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------





--

Dave Peterson