Option Buttons with Formulas in Excel

Excel File: www.teachexcel...
Excel Courses: www.teachexcel...
(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.micros...
Checkbox Control in Excel: www.teachexcel...
Excel Courses:
VBA/Macro Course: www.teachexcel...
Building Professional Forms: www.teachexcel...
Email Course: www.teachexcel...
TeachExcel.com
#msexcel #howto #tutorial

[@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!

[@TeknoMaX]

Sir, you have a VERY soothing voice... borderline ASMR.

[@wayneedmondson1065]

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

[@muhammadqasimali7736]

Great tutoring and simple understanding.

[@aderaldojunior]

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

[@IvanCortinas_ES]

Thank you Don. Great video!!

[@tomaszlitke4303]

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

[@emmanuelakpan3339]

Thanks a lot for sharing. Really enjoyed the video

[@FRANKWHITE1996]

Another great video! Thanks for sharing!!

[@gelayc0517]

🙏🫰🫰🫰🙌🙌 very helpful tnx!!!

[@alexanderenriquebolanotriv4820]

Gracias por la explicación, Buen trabajo!

[@ChitChit-n4f]

1:02 1:05

[@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

[@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?

[@whiteshadow1807]

How to unselect or reset the selection?😅

[@neremoli4990]

Switch function not working with windows 7 office 10

[@warrenhall1750]

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

[@GandalfGreyy]

You sound exactly like Brad Pitt