I am trying to add the value of checked, checkboxes within the range of D35-D71 and D74-D95 with the total going into F14. Please see attached file. I am new to VBA, please see the code I tried using. Any advice would be greatly appreciated.
Please Login or Register to view this content.
Last edited by MAI2010; 06-23-2013 at 10:32 AM.
Bump no response
Hi MAI2010
Try the Code in the attached...let me know of issues.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
John,
Thank you very much, works great! Would you please explain to me what exactly you changed? I'd like to know so I can replicate this in the future if changes are needed. Thank you again.
Hi MAI2010
You're welcome...glad I could help. Thanks for the Rep.
Since you have a multitude of CheckBoxes I've introduced a Class Module to monitor the changes in the applicable CheckBoxes...otherwisie you'd need to write Change Event Code for each applicable CheckBox.
You will see that much, if not most, of the Code I introduced is taken from here...study it...you'll understand...
http://www.bettersolutions.com/excel...A619860332.htm
If you're using MANY CheckBoxes, TextBoxes, ComboBoxes, etc, Class Modules are, in my opinion, the approach to take.
Thank you for response and extra study material lol Seriously though, I really appreciate the help!
You're welcome...and welcome to the ride of VBA...you'll enjoy it...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks