Channel: ExcelVbaIsFun

Category: Education

Tags: excel tutorialreportshow todatathisworkbookexcelvbaisfuneasy visual basicrangetrainingvba excelcomputerms excelmicrosoft visual basicvisual basiceasy exceltutorialfreereportingprogrammingeasy vbaexcel shapesmacrodebuglessonms excel vbavba shapeexcelexcel basicsvbaexcel visual basicdan strongvba tutorialhdexcel vbavba basicsvisual basic tutorialobject

Description: 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 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 Excel VBA Essentials Course: bit.ly/UltExcelVBA Control Websites With Excel VBA: bit.ly/VbaWebAutomation Speed Up Code With VBA Arrays: bit.ly/VbaArrays Create Your Own Functions/Addins: bit.ly/CustomUDFsAddins Fill PDFs/Forms with Excel VBA: bit.ly/VbaPDFsMastery Excel VBA Barcode Lookup System & Inventory Projects: bit.ly/VbaBarcodesProjects Instantly Secure Excel Files; Transform Into EXE Programs!: bit.ly/Excel2EXE Automate Outlook with Excel VBA: bit.ly/ExcelVBAOutlook Professional Animations In Excel by Kishon: click.linksynergy.com/deeplink?id=BYzUIhHF1Ys&mid=39197&murl=https%3A%2F%2Fwww.udemy.com%2Fmicrosoft-excel-animation-for-great-user-experience%2F Fantastic Developer Tools: Lock Any Workbook Into An EXE (Software only, see course above): excelvbaisfun.com/get-xlspadlock Create Custom Installers: excelvbaisfun.com/get-pb Free Ebook: excelvbaisfun.com/FreeEbook Dan Strong's Articles: excelvbaisfun.com/blog Free Excel Workbooks: excelvbaisfun.com/free-workbooks Business Inquiries, Consulting, Comments, etc: excelvbaisfun.com/contact ExcelVbaIsFun YouTube Playlists: Excel Vba Basics: bit.ly/ExcelVbaBasicsPlaylist Tips N Tricks: bit.ly/VbaTipsNTricksPlaylist Userforms: bit.ly/ExcelVbaUserformsPlaylist Events Series: bit.ly/VbaEventsPlaylist Activex Controls: bit.ly/VbaActiveXPlaylist Sample Excel Programs: bit.ly/SampleExcelPrograms Where else you can find me: LinkedIn: linkedin.com/in/danielcstrong Facebook: facebook.com/Excelvbaisfun Twitter: twitter.com/ExcelVbaIsFun Google Plus+: google.com/+ExcelVbaIsFun T-Shirts/Merch: ExcelVbaIsFun.spreadshirt.com 'Royalty Free Music by audiomicro.com/royalty-free-music'