Use Shapes as Option-Buttons - Auto Coloring Groups

📊 Free Workbooks: https://www.excelvbaisfun.com/links?utm_source=youtube&utm_medium=desc&utm_content=JljB4ofuC1A
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapro🔥(2 Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

Shapes in Microsoft Excel don't naturally allow you to click on one and for it to obtain a color, while the other shapes in a group will turn grey. In this video, I'll show you how to take a cluster of shapes and allow the user to click on one button and all other buttons become grey. It's powerful, because this could become the next generation of option buttons/option groups!
Download the file 👉https://bit.ly/3sHlqqT

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-excel-files (25% off with code ‘25OFF’)
🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-installers
👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/

00:00 Intro
01:22 Get Shape Color Code
02:05 Explaining Recorded Code
02:41 Clean Up Code!
04:10 Dealing With Typical Shape Issue
05:35 Make it Dynamic - Any Shape Grey
07:24 Making Multiple Color Macros
09:10 Labeling System
12:08 Which Button Called the Macro?
14:27 Get Group Name If Exists
15:56 Error Planning
17:43 Looping Through Shapes in a Group

Видео Use Shapes as Option-Buttons - Auto Coloring Groups канала ExcelVbaIsFun