Bonbon's Guide To Data & Tech

Microsoft Excel Tutorial: Multi-select all checkboxes and flip from true to false or back.

To download the workbook from today: https://www.mrexcel.com/youtube/mpQ7IrPzenM/

Copy this code and put it in your personal macro workbook:
Sub FlipCheckboxes()
On Error Resume Next
For Each cell In Selection.SpecialCells(xlCellTypeConstants, 4)
cell.Value = Not (cell.Value)
Next cell
On Error GoTo 0
End Sub

Sub AllTrueCheckboxes()
On Error Resume Next
For Each cell In Selection.SpecialCells(xlCellTypeConstants, 4)
cell.Value = Continue reading “Excel VBA Macro To Flip All Checkboxes In Excel – Episode 2629 #excelhacks” →

Microsoft Excel Tutorial: Better looking checkboxes in Excel.

📊 Want to upgrade the look of your Excel checkboxes? In October 2023, a new Checkbox icon was introduced on the Insert tab. While it offers a convenient way to toggle checkboxes using your mouse or the spacebar, it can feel a bit cluttered.

👉 In this quick tip, discover a sleeker alternative! Learn how to add checkboxes and then make them disappear with a simple press of the Delete key. They’ll reappear when you hover over the cells, and with a click or spacebar press, you can easily turn them on.

🔘 However, keep Continue reading “Excel – Better Checkbox Style in Excel – Quick Tips #shorts #excelhacks” →

Microsoft Excel Tutorial: Checkboxes arrive in Microsoft Excel

To download the workbook from today: https://www.mrexcel.com/youtube/kunbe45v7-E/

In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district.

Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the “Insert” tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true Continue reading “Excel – Exciting! Checkboxes Arrive In Excel – Episode 2628” →

Microsoft Excel Tutorial: Calculate Average Cost per Year in Excel.

Derek has a fleet of vehicles and a list of all repairs made in the last 20 years. He wants to figure out how the annual repair and maintenance costs change as the vehicle ages.

In this video, MrExcel discusses how to calculate annual repair costs based on the age of a vehicle. He provides a data set of repairs made on a fleet of vehicles and explains how to determine the first date each vehicle was placed in service. He suggests using an approximation for vehicles without records by subtracting Continue reading “Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627” →