LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Range Names by worksheet FlaAl Excel Discussion (Misc queries) 0 May 24th 06 05:14 PM
The filter didn't show all (2,254) names when I set it up Darrell Excel Discussion (Misc queries) 2 December 17th 05 04:25 PM
Convert Local Names to Global Names Ed Excel Worksheet Functions 1 November 30th 05 05:23 PM
sorting names alphabetically when names may start with numbers John Smith Excel Discussion (Misc queries) 3 May 11th 05 08:06 PM
How can I find the common names in two columns of names? hako Excel Discussion (Misc queries) 2 December 8th 04 01:59 AM


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"