Option Buttons with Formulas in Excel

Excel File: www.teachexcel.com/excel-tuto...
Excel Courses: 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): support.microsoft.com/en-us/o...
Checkbox Control in Excel: www.teachexcel.com/excel-tuto...
Excel Courses:
- VBA/Macro Course: www.teachexcel.com/vba-course...
- Building Professional Forms: www.teachexcel.com/premium-co...
- Email Course: www.teachexcel.com/premium-co...
TeachExcel.com
#msexcel #howto #tutorial

[@wayneedmondson1065]

Awesome! Thanks for the Option Buttons tips. Nice use of CHOOSE and SWITCH :)) Thumbs up!!

[@johnruszkowski6232]

Another tip (to save time aligning the input buttons). Place the top button at the right height in your Group, likewise for the last/bottom, with one button as far left as you want them.
Then right click select one option button and Ctrl+Shift to select others. Go to ribbon Page Layout/Align (under Arrange) then first click Distribute Vertically followed by Align Left.
Job done!

[@emmanuelakpan3339]

Thanks a lot for sharing. Really enjoyed the video

[@IvanCortinas_ES]

Thank you Don. Great video!!

[@alexanderenriquebolanotriv4820]

Gracias por la explicación, Buen trabajo!

[@FRANKWHITE1996]

Another great video! Thanks for sharing!!

[@muhammadqasimali7736]

Great tutoring and simple understanding.

[@aderaldojunior]

Oh my! As simple as life should be. Thx!😜

[@tomaszlitke4303]

Here is a tip: If you hold an "alt" when you draw a object it will position it to the cell itself.

[@gregorytaylor2749]

I am confused on how the value in A1 is derived. Does it come from the ordinal value of the button that is clicked?

[@fionamckay4451]

I have 4 independent button options on one sheet. No matter what I do (and I have repeatedly done exactly what you say, step by step), the buttons remain linked. I start each button set from scratch. But choosing an option in one set, cancels the selection from any other set. Can you HELP?!

[@ankurpal3872]

How to increase font size of option button

[@neremoli4990]

Switch function not working with windows 7 office 10

[@whiteshadow1807]

How to unselect or reset the selection?😅

[@warrenhall1750]

It's "an apple, an Orange".".

[@GandalfGreyy]

You sound exactly like Brad Pitt