Thread
:
Form control names
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
Form control names
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
Chip Pearson
View Public Profile
Find all posts by Chip Pearson