Hello everyone
I have eight Checkboxes and each of them has a Macro assigned to it. The way I did it takes a moment to execute the Macro.
I am asking you if it is possible to combine these Macros into one and assign this Macro to all eight CheckBoxes
Thank you in advance for your help.
Please Login or Register to view this content.
in class module name of class is ClsEvents
in userform initializePlease Login or Register to view this content.
Please Login or Register to view this content.
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
or like this
Please Login or Register to view this content.
deleted by me
Last edited by daboho; 05-12-2024 at 03:56 PM.
Without the workbook and checkboxes, this hasn't been tested in context, but I would have thought you could just combine the code like this:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
What kind of CheckBoxes? FormControl or ActiveX?
On a Sheet or on a UserForm?
Experience trumps academics every day of the week and twice on Sunday.
If your Checkboxes are Form Control Checkboxes, are named like in your code from Post #1 and are on a Sheet, would this not be simpler?
One little Macro for all CheckBoxes.
Please Login or Register to view this content.
I guess nothing worked as we haven't heard anything like "Thank you" or "No it did not work the way I planned it."
No interest?
Join Date 02-04-2024
Last Activity 05-12-2024 08:26 PM
Presumably saw the first response from daboho.
Hi Trevor.
What is this world coming to? If it was not for you and me, and maybe a few others, it would be a heck of a mess!!!!!!!
I guess we'll live with it.
Have a good one.
I'm sorry and I apologize again but I didn't have access to the Internet!!!
No worries.
You're welcome. Thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks