Premium Only Content

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
-
LIVE
Redacted News
1 hour agoBREAKING! TRUMP AND PUTIN NEARING PEACE BUT EUROPEAN WARMONGERS TRYING TO STOP IT | REDACTED
12,693 watching -
52:40
Candace Show Podcast
1 hour agoSaturday Night Lively: What Were They Thinking? | Candace Ep 148
15.4K18 -
LIVE
Revenge of the Cis
2 hours agoEpisode 1449: Boo This
2,009 watching -
1:20:31
Awaken With JP
3 hours agoWiping Hard Drives, Hire a Criminal Defense Lawyer - LIES Ep 79
44K25 -
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
39.2K22 -
LIVE
Game On!
1 hour agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
48 watching -
LIVE
John Crump Live
4 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
123 watching -
LIVE
The Nunn Report - w/ Dan Nunn
1 hour ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
275 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
4.95K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $0.84 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1