Thread
:
Form control names
View Single Post
#
6
Posted to microsoft.public.excel.programming
Howard Kaikow
external usenet poster
Posts: 269
Form control names
Ah yes, I now recall that from daze of yore.
--
http://www.standards.com/;
Howard Kaikow's web site.
------------------------------------------------
"Chip Pearson" wrote in message
...
Howard,
I am referring to the name dropdown box to the left of the formula
bar, not the Names dialog box.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Howard Kaikow" wrote in message
...
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.
------------------------------------------------
Reply With Quote
Howard Kaikow
View Public Profile
Find all posts by Howard Kaikow