Option Buttons with Formulas in Excel

Excel File: https://www.teachexcel.com/excel-tutorial/2459/option-buttons-with-formulas-in-excel?nav=yt
Excel Courses: https://www.teachexcel.com/premium-courses/?src=youtube_v_ucRUNwEXepM

(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/en-us/office/add-a-check-box-or-option-button-form-controls-9f201e46-8f6b-4a9d-a320-f44b28088cb0
Checkbox Control in Excel: https://www.teachexcel.com/excel-tutorial/2453/simple-checkbox-control-in-excel

Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_ucRUNwEXepM
- Email Course: https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_ucRUNwEXepM

TeachExcel.com

#msexcel #howto #tutorial

Видео Option Buttons with Formulas in Excel канала TeachExcel