Option Buttons with Formulas in Excel
Excel File: https://www.teachexcel.com/excel-tuto...
Excel Courses: https://www.teachexcel.com/premium-co...
(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/o...
Checkbox Control in Excel: https://www.teachexcel.com/excel-tuto...
Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vba-course...
Building Professional Forms: https://www.teachexcel.com/premium-co...
Email Course: https://www.teachexcel.com/premium-co...
TeachExcel.com
#msexcel #howto #tutorial
Watch video Option Buttons with Formulas in Excel online without registration, duration hours minute second in high quality. This video was added by user TeachExcel 20 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 91,260 once and liked it 813 people.