hello everyone,
I have this code
and I need only one thing : checkbox is now named "Check box 2" it is possible to rename it somehow to e.g. "pin2" ? (it means like this :
Please Login or Register to view this content.because I have more than one checkboxes and after some time it will be difficult to know which checkbox has its name ... thanks !Please Login or Register to view this content.
Last edited by miso.dca; 12-21-2009 at 02:45 PM.
Select the CheckBoxthen you will see it's name in the Name Box at the top of the sheet. Change it in the name box & click Enter
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Your code will run more efficiently if you do not Select sheets and/or Ranges
Please Login or Register to view this content.
yes, I did it before but I've got this message : "Unable to get the Checkboxes property of the Worksheet class"(btw. I can't named it "PIN2" because after clicking enter Excel got on cell PIN2, I have to use PIN-2 (this isnt problem) )
Not sure what you mean, attach the workbookOriginally Posted by miso.dca
yes, I did it before but I've got this message : "Unable to get the Checkboxes property of the Worksheet class"
ok, I uploaded excel with my problem, thanks for help !
(btw. there are two checkboxes ... first which is named pin-2 (I renamed it - from check box 1 to pin-2) and second which I didnt renamed and it has name check box 2)
I've added a CheckBox from the Forms menu & renamed it Pin2 & the code runs fine
Please Login or Register to view this content.
heh ... that's strange ... first I named it "pin" and it didnt work, now I named it "pin" and everything is finebut "pin-2" doesnt work, maybe because of "-" ... who knows
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks