Excel VBA ActiveX Series #3 Option buttons - Use on a sheet, How to group, Select with VBA

Рет қаралды 75,551

11 жыл бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
Option buttons allow the user to pick ONLY ONE choice from multiple option buttons. When you select one of the option buttons, the others in that group are automatically de-selected (set to FALSE).
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Пікірлер: 15

@krn14242 11 жыл бұрын

Cool, thanks Dan. I have always been wanting to learn VBA and you make it pretty easy to try stuff.

@ExcelVbaIsFun 10 жыл бұрын

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

@karimachaibou1393 11 жыл бұрын

To make groups of optionbuttons you need to use the property GroupName in the properties menu. eg group1; group2; ...

@moustick2025 5 жыл бұрын

thank you , I was looking for this information so bad

@missjol 9 жыл бұрын

How can I click more than one option button at a time?

@ExcelVbaIsFun 10 жыл бұрын

You're welcome johnyraku! Dan

@ExcelVbaIsFun 11 жыл бұрын

Wow, thanks for that comment!

@sandeepkothari5000 6 жыл бұрын

Gr8!

@user-oo4nj8jg5y Жыл бұрын

how to used optionbottons to save input data from entry form to difference workbook?

@lilarouge143 7 жыл бұрын

Do you know how to use 2 option buttons linked to a formula so that when one is selected it runs a formula to calculate a group of cells and the other option button is not calculated? So basically only one calculation can be performed at a time. I'm having trouble with this.

@fernandomaluenda4226 6 жыл бұрын

He has more categories than I do, my property tab only shows 13 categories. How can I add all the ones you have?

@nixland 4 жыл бұрын

How to access option button value from a standalone subroutine on that sheet? I use shape method to get the option button object but always get error. Frustating.