Macro code to check if all checkboxes on userform are false

**WilliamWu** · 12-01-2013, 02:05 PM

Hello

I have a userform with multiple checkboxes (more than 12). If all the checkboxes are unchecked (value = false) then the user cannot proceed, at least one of the checkboxes must be checked. I'm not sure how to write a macro to evaluate this condition.

Thanks

**noboffinme** · 12-01-2013, 03:25 PM

Hi WilliamWu,

If you can use Radio Buttons instead of checkboxes, you can put the Radio Buttons inside a Frame & it will automatically only allow selection of one Button.

Hth.

**Sbarro79** · 12-01-2013, 03:33 PM

Maybe something like this:

Please Login or Register  to view this content.

Macro code to check if all checkboxes on userform are false

LinkBack

Thread Tools

Rate This Thread

Display

Macro code to check if all checkboxes on userform are false

Re: Macro code to check if all checkboxes on userform are false

Re: Macro code to check if all checkboxes on userform are false

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Please help! macro code needed to assign to command button to check a column of checkboxes

Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro

vba code/macro to check checkboxes

[SOLVED] VBA code - unable to check checkboxes (userform) in Excel 2010

[SOLVED] Macro to make all checkboxes false and clear all comboxes

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions