Ensure a Single Check Box Selection
Check boxes are supposed to be used to allow multiple selections. But since they are now so easy to insert, you might want to use them to allow a single selection. Here’s one way to do that.
(more…)Excel and ActiveX Controls
Microsoft has recently turned off ActiveX controls as default. If you have used them in the past and still want to use them you will need to turn them back on.
(more…)Checkboxes as a Visualisation in Excel
I have covered the new checkboxes in Excel in a previous post. Typically, they are used as a simple user interface to turn off or turn on an option. But I learned recently that you can also use them as a visualisation.
(more…)Updating Sentences in Excel with New Techniques
I wrote a blog post back in 2012 and showed how to use checkboxes to build a paragraph based on sentences you select. I thought I would update it with recent new techniques.
(more…)One Minute to Excel #13 – Create and Use a Check Box
A check box is an easy interface to create and use. See how to add one to a sheet and use it in a calculation. https://vimeo.com/529248845
Free Excel Webinar Recording – Mastering Form Controls
In March 2019 I demonstrated how to use some of Excel's Form Controls. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/322983267 Learn how to build better spreadsheet interfaces using form controls like check boxes, scroll bars, option buttons and combo boxes. Form controls can reduce the number of input errors; simplify and speed…
Controlling a Conditional Format with a Checkbox
Here is a technique that allows you to turn off and turn on the conditional format without actually removing the conditional format. You may want to do this to print a sheet without the conditional formats being applied. (more…)
Validating Checkbox Linked Cells
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. (more…)
How Not to Print an Image in Excel
If you want to place graphic objects on your sheet eg logos and checkboxes, but not have them print out, you need to change their properties. (more…)
Handling graphics in Excel
If you need to move or amend a lot of graphics at once Excel has a feature that can save you time and effort. It’s been around for a while, but it’s been hidden away in the latest few versions. (more…)
Excel’s writing skills
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. (more…)
How and why you should use Check Boxes in Excel
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. (more…)