Excel Yourself: The Check Box control

Excel Yourself

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.

How-to articles, sample spreadsheets and more

Excel yourself

Combine annual and monthly data in Excel with these simple steps

Making data relationships work

Easy steps to make data Relationships work in Excel

Excel Yourself

Easy tips for matching salary to job class in Excel