When you create a checkbox you need to link it to a cell on a sheet to be able to use its result. The user could overwrite that linked cell with a value or text and affect formulas that are using the checkbox linked cell. You can add a validation to make sure the linked cell only contains TRUE or FALSE.
Tag Archives: controls
Running an Excel Macro from a Graphic
Its easy to set up
These days running a macro off a control button seems to be old school and many people have started running macros off graphics.
Excel’s writing skills
Tick and create
Excel is great with numbers but what about sentences? Check out this example of how you can create a paragraph builder. The user ticks boxes to select sentences to include in a paragraph.
How and why you should use Check Boxes in Excel
Make it stick with a tick
Check boxes make selections easy. Excel has a number of useful controls that can be added to sheets to improve the user interface. These include check boxes (tick boxes), option buttons and spinner controls.