Option Buttons with Formulas in Excel

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

[@tomaszlitke4303]

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

[@aderaldojunior]

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

[@emmanuelakpan3339]

Thanks a lot for sharing. Really enjoyed the video

[@IvanCortinas_ES]

Thank you Don. Great video!!

[@gelayc0517]

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

[@FRANKWHITE1996]

Another great video! Thanks for sharing!!

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

[@alexanderenriquebolanotriv4820]

Gracias por la explicación, Buen trabajo!

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

[@neremoli4990]

Switch function not working with windows 7 office 10

[@ankurpal3872]

How to increase font size of option button

[@whiteshadow1807]

How to unselect or reset the selection?😅

[@warrenhall1750]

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

[@GandalfGreyy]

You sound exactly like Brad Pitt