Providing interactive choice at key points in an Excel sheet can be very useful and a macro makes adding multiple Check Boxes easier.
A Check Box control is a graphic image that floats above the Excel grid.
When you click it, you add or remove a tick from the box.
The Check Box control is linked to a specific cell. A ticked Check Box inserts TRUE into that cell, while an unticked Check Box inserts a FALSE. The Check Box is an easy-to-use interface.
Want to learn more? Download this sample Excel file and check out our video tutorial above.
Neale Blackwood CPA runs A4 Accounting, providing Excel training, webinars and consulting services.