Configuring Form Control Option Buttons in Excel

  Рет қаралды 51,610

Dr. Todd Grande

Dr. Todd Grande

Күн бұрын

This video demonstrates how to configure Form Control Option Button in Excel. Using the Form Control Group Box to separate option buttons is reviewed. The CHOOSE function is used to select values from a data set with the cell link value from the option buttons.

Пікірлер: 8
@neilcannon724
@neilcannon724 5 жыл бұрын
Perfect video! Not too wordy and helped me understand Option Buttons and Group Boxes that I have never used before! Thank you, Todd.
@rodlusk1649
@rodlusk1649 5 жыл бұрын
Dr. Grande; best video I could find on option buttons. I understand the principle and I can get it to work as it should. I am grouping two option buttons for yes and no in a row that will be an answer to a question. My problem is when I group them from the developer tab the reference cell link does seem to hold or stick. It will change to another question and create another yes/no group for a different question and group the second set of answers the first group doesn't seem to hold. When I go back into formating and change the first set back the the cell I want it to be, when I click on the option button in another group it changes back even though I have fixed it with $$ for both row and columns. This really has me stumped frustrating. I hope this makes sense and you can point me to what I'm doing wrong. Thank you for the video's. Rod
@JoeMontgomeryCPA
@JoeMontgomeryCPA 4 жыл бұрын
Great Video Todd! Thanks for the help.
@soundzzzoflife5541
@soundzzzoflife5541 7 жыл бұрын
Can you link category names to option buttons and hide category column when button is selected?
@kurtcinco7108
@kurtcinco7108 5 жыл бұрын
how do you disable a form control button in excel-vba?
@niklaslechler
@niklaslechler 6 жыл бұрын
how can I set a whole coloumn =0 by clicking on a button?
@sturmcstacee
@sturmcstacee 6 жыл бұрын
How do you unlink an option button? I have two sets of option buttons for different info, but cant seem to unlink one set from another. Please help?
@aurinwongpichit1019
@aurinwongpichit1019 5 жыл бұрын
I have four options / 1 question... And i can do it until the 5th question.... Then the options of 4th and 5th question have conflicked... I tried to close, delete, create the groupbox again... But it does not work any more.
Option Buttons with Formulas in Excel
8:44
TeachExcel
Рет қаралды 85 М.
Adding Data to Excel using Option Buttons on a VBA UserForm
16:51
Dr. Todd Grande
Рет қаралды 41 М.
🤔Какой Орган самый длинный ? #shorts
00:42
Despicable Me Fart Blaster
00:51
_vector_
Рет қаралды 22 МЛН
Excel VBA Forms Part 8 - Option Buttons
27:31
WiseOwlTutorials
Рет қаралды 33 М.
Using Spin Buttons in Excel
10:19
Technology for Teachers and Students
Рет қаралды 101 М.
Form Controls - Excel for Advanced - Lesson 13
19:14
Comprehensive Courses
Рет қаралды 30 М.
Selecting Values with a Form Control Listbox on an Excel Worksheet
7:00
Configuring a MultiPage Control on an Excel VBA UserForm
15:34
Dr. Todd Grande
Рет қаралды 46 М.
Dynamic Conditional Formatting With Option Buttons without VBA
10:34
PK: An Excel Expert
Рет қаралды 10 М.
Make Cool Buttons for Excel! (And Professional)
9:19
TeachExcel
Рет қаралды 51 М.