PDA

View Full Version : Limiting the number of checkboxes to be selected



tomtom412
03-14-2017, 05:37 AM
Hello all

I have 3 checkboxes and want to be only able to select any 2. After selecting any 2 checkboxes, the others are "greyed out" or unavailable to be selected until one of the already selected 2, become unselected.

I then want the captions of the check boxes to be outputted to 2 cells on my sheet.

This concept is way beyond my abilities in coding in VBA and so I need to ask for help! Any at all would be greatly appreciated!
I've attached a sample book to give clarity in what im doing!

Thanks
Tom

GTO
03-14-2017, 05:49 AM
Greetings,

I see that you just joined the forum. Welcome to VBAExpress.

You cross-posted Here (https://www.mrexcel.com/forum/excel-questions/995746-limiting-number-checkboxes-selected.html). Please read through the rules of the forum and I would suggest This Article (http://www.excelguru.ca/content.php?184) reference cross-posting.

Mark