Option Buttons with Formulas in Excel

Рет қаралды 84,188

3 жыл бұрын

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

Пікірлер: 16

@johnruszkowski6232 3 жыл бұрын

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!

@wayneedmondson1065 3 жыл бұрын

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

@aderaldojunior Ай бұрын

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

@tomaszlitke4303 3 жыл бұрын

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

@muhammadqasimali7736 Ай бұрын

Great tutoring and simple understanding.

@alexanderenriquebolanotriv4820 2 жыл бұрын

Gracias por la explicación, Buen trabajo!

@IvanCortinas_ES 2 жыл бұрын

Thank you Don. Great video!!

@emmanuelakpan3339 3 жыл бұрын

Thanks a lot for sharing. Really enjoyed the video

@FRANKWHITE1996 2 жыл бұрын

Another great video! Thanks for sharing!!

@gregorytaylor2749 3 жыл бұрын

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 11 ай бұрын

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