I have 71 checkboxes that I want to transfer the Checkbox Caption if true. If the checkbox is false I want to transfer a value of "0". The captions are being transferred to a different worksheet. Below are a few entries if I was to enter them all separately, but I assume there is a way to do all at once? Help please!
Please Login or Register to view this content.
Hello janicesm,
I am assuming the CheckBoxes were created sequentially i.e. CheckBox1, CheckBox2, CheckBox3 to CheckBox71.
Will the cells also be sequential from A3, A4, A5 to A73?
Are these Forms or ActiveX CheckBoxes?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi.
The checkboxes are a little bit out of order (and a couple missing) - however if it is imperative that they are all sequential I could go back and fix that.
Yes, the cells are sequential.
These are ActiveX Checkboxes residing directly on a worksheet.
Thanks.
Hello janicesm,
Since you are using ActiveX controls, they can be easily Subclassed. Subclassing allows each control of the same type to share a common set of properties, methods, and events.
Because this technique is a bit advanced, it would be best if post your workbook. I can then add the needed macros for you and test it.
ExcelForum.xlsm
Not sure if I attached this right, but here it goes! I have included the two relevant pages.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks