Not in the Beta Channel, but really don't want to wait for Boolean CheckBoxes?

For those like myself who are unable to join the Beta Channel due to your companies IT policies, but really want those Boolean Checkboxes you've seen on Social Media, I've worked out a solution!

It's not perfect, but it works exactly the same from what I can tell.

1. Open Personal.xlsb
2. Create a module
3. Enter this code;

Please Login or Register  to view this content.

4. Save to Personal.xlsb

5. Add to the Ribbon for quick access.

Now all you have to do is select the Cell(s) you wish to insert the CheckBox(s) in, and hit the button in you created on the ribbon.

When the CheckBox is Checked, referencing the cell it sits in will return TRUE, and unchecked will return FALSE.

Enjoy!