No video :(

Option Buttons with Formulas in Excel

Подписаться 254 тыс.

Просмотров 89 тыс.

50% 1

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

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

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

@TeknoMaX Месяц назад

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

@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 3 месяца назад

Great tutoring and simple understanding.

@wayneedmondson1065 3 года назад

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

@aderaldojunior 3 месяца назад

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

@gelayc0517 24 дня назад

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

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