Mandatory Checkboxes (Form Control)
Morning All,
Can anyone please kindly assist in my quest to make a set of Form Control Checkboxes mandatory input please?
They're in cell range I24:I27 on my sheet
I've had a sift through 6 pages on the forum search for Mandatory Checkboxes and a Googling session besides and can't see anything immediately relevant, but then in my Newb state I probably wouldn't know it to look at it lol!
Any help appreciated!
MKW
Hi,
Please attached sample excel to clarify what is the expected output and how your file looks and what controls are used?
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Handover Example.xlsm
Example file is attached for reference as requested, if anything is unclear about how it's intended to work please ask. Bear in mind my technical knowledge is rather limited on VBA, I'm just starting to learn, so humour me with additional details when advising how to handle this as I might not 'get' it entirely first time around!
Your help is appreciated!
MKW
Hi,
Check the attached file, I have done validation for one checkbox i.e Check box 47.
Handover Example.xlsm
To check the check boxes names, right click the check boxes and check the name box at the left top corner besides formula bar.
Note: To check the code, goto code and check the subroutine test().
I have added ElseIf part.
Regards,
Paresh J
Thank you, Paresh. I've had a look and I think I understand what's going on
I'll experiment with it this evening and leave you some feedback as to how I get on!
MKW
Hi,
Ok, Check how this works out and any further help required please let me know. If not required then you can mark this thread as SOLVED and click * to add reputation as way to say thanks...
Regards,
Paresh J
Hi Paresh,
Works great thanks!
Neat little trick that!
Thanks for your help.
MKW
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks