Excel File: https://www.teachexcel.com/exceltuto...
Excel Courses: https://www.teachexcel.com/premiumco...

(A big thanks to Wayne for mentioning this in a comment to a previous video I made! This is a great addition to using check marks [tutorial linked below])

How to make Excel option buttons in a worksheet that are linked to formulas and functions within the worksheet.

This allows you to control entire worksheets using option button form controls.

You can even control conditional formatting, data validation, and any other element of a worksheet that uses or relies upon a formula.

Other Resources:
Option Buttons in Excel (msft): https://support.microsoft.com/enus/o...
Checkbox Control in Excel: https://www.teachexcel.com/exceltuto...

Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vbacourse...
Building Professional Forms: https://www.teachexcel.com/premiumco...
Email Course: https://www.teachexcel.com/premiumco...

TeachExcel.com

#msexcel #howto #tutorial