Excel ActiveX Combo Box to Select Worksheets with VBA
September 20, 2018 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
You'll learn how to create a handy navigation combo-box for your Excel workbooks. The ActiveX combobox is automatically filled with the sheet names of your open workbook. If you add sheets, these are automatically added to the drop-down box. Deleted sheets are automatically removed from the combo-box.
You can get the complete Excel VBA and macros course here: https://courses.xelplus.com/p/excel-vba-excel-macros
What you learn in this video:
You learn how to work with ActiveX controls in Excel - what "design view" is and how to adjust the properties to ActiveX controls. You also learn how to fill the values of the the drop-down on the fly so the macro is executed without the need to press a button to run it.
You learn about Active X events - how to debug your VBA code and also how to tweak it so it performs better.
🡻 Download the workbook here 🡻
https://www.xelplus.com/excel-activex-combo-box-with-vba/
★ Links to related videos: ★
Check out my VBA playlist here: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #LeilaGharani
-
1:48:03
The Podcast of the Lotus Eaters
7 hours agoThe Podcast of the Lotus Eaters #923
34.8K23 -
1:44:50
jeffahern
4 hours agoMonday Madness with Jeff Ahern (6AM Pacific)
17.8K5 -
25:18
CarlCrusher
15 hours agoCurse of the Skinwalker | The Ancient Mystery of Magic Mesa - Full Documentary | Part 5
12.7K4 -
32:00
Blue Siesta ASMR
19 hours agoASMR General Knowledge Quiz | 10 Questions Soft Spoken
16.2K4 -
13:38
JoBlo Horror Originals
3 hours agoWhat Happened To Texas Chainsaw Massacre (2022)?
8.17K1 -
10:50
Yarnhub
6 hours agoWW1 Balloon Buster and the Chinese Balloon
13.2K2 -
12:33
Degenerate Jay
1 day agoAssassin's Creed 2's Best Feature Changed The Series Forever
13.3K1 -
1:21:37
Roseanne Barr
2 days ago $103.27 earnedKevin Sorbo saves America | The Roseanne Barr Podcast #49
167K569 -
8:13:09
Akademiks
21 hours agoIs It OVER for DRAKE?? Industry and Fans Turned on him? Cassie Tryna not get CHARGED w/ Diddy?
99.5K176 -
3:57:39
FusedAegisTV
17 hours agoMax Payne 3 (2012)... For Real Now | When Western Games Weren't Ghey #1 RUMBLE CREATOR HOUSE EDITION
51.1K21