📊 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)
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 👉bit.ly/3sHlqqT
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/
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
Пікірлер: 20