Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
See names of controls
When I use the Forms Toolbar to put a checkbox on a worksheet, it names the
control 'Check Box 1' and sets its Text property to that name. That's nice, except that I always change it (right-click and Edit Text) so that the text is something else, and then I cannot see the name of the control after the edit of the Text. When I use OLE to access (read the state of) the checkbox from an external program, it needs to know the name of the control. Since the Text property was edited to something other than the original control name, the only way I've found to determine the name of the control in Excel is to right-click on it and choose "Assign Macro" because the propsed macro name has the control name embedded in it. Is there some more convenient way to tell the name of a checkbox control on a spreadsheet? -- I am The Math. You know what to do. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
Convert Local Names to Global Names | Excel Worksheet Functions | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |