In my Userform I would like to stop a command button from being pressed until a minimum of 5 checkboxes out of 10 have been selected.
I have a total of how many checkboxes have been selected. How do I write the code on the command button that if Label X (which has the total of the checkboxes) is greater than 4 then run the Comman Button to exit Excel.
Thank you for your help.
Use a textbox instead of label and try to code something like this...
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You could do it this way.
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
my variation
did not do proper naming but you get the idea
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks