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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
See names of controls
I now see that the control name is there in the Name Box when the control is
dropped onto the spreadsheet, and that when I move to some other control by pressing <Esc or by just clicking on some other cell, then returning to the checkbox cell using the arrow keys results in the Name Box showing the cell row and column instead of the component name. If I right-click on the cell, then it is highlighted in a different mode, and the Name Box once again shows the name of the control. This is handier than having to follow that with a menu selection just to see the control name. I can then <Tab to subsequent cells that contain checkboxes and each of them are selected in this alternate mode, with the Name Box showing the control name, as desired. Thanks Nick. -- I am the math. You know what to do. "Nick Hodge" wrote: TheMath It remains in the 'name' box. (Left of the formula bar) |
Reply |
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) |