dimanche 3 septembre 2023

VBA Code to ensure that at least one checkbox is checked

I have a form (titled ReplacedParts) that is opened from original form (frmForm) and it uses checkboxes to track what parts were replaced on a rebuild. A total of 26 checkboxes. After you select the parts replaced, you press "Accept Changes" button. If no boxes are checked then i want there to be a msgbox pop up and i don't want the user to be able to continue until at least one box is checked. If at least one is checked, then i want ReplacedParts to hide (thus revealing the original form) and yes, i did include a last box for no parts replaced. Just need a little bit of code that would accomplish this.

I tried a few different ideas i found online but nothing has worked so far.




Aucun commentaire:

Enregistrer un commentaire