Premium Only Content

Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA
May 2, 2019 Excel VBA & Macros Tutorials
In this Excel VBA & macros tutorial, learn how to automatically display all worksheets in an Excel ActiveX List Box and print multiple sheets as one print job. You can also use the same code to print preview multiple worksheets in one Excel print preview window.
★ Complete Excel VBA and macros course: https://courses.xelplus.com/p/excel-vba-excel-macros
This VBA tutorial builds on the a previous video where we displayed all worksheets in an Excel ActiveX Combo Box - selecting a sheet name from the combo box, sent the user to the respective sheet.
This time we will be using an ActiveX ListBox to allow the user to print the selected sheets in one go. We will use the Excel Worksheet Activate event to automatically populate the list of sheet names in the List Box.
We will then use the VBA For Next Loop to create a string array of the sheet names that were selected. To do this, we will use the VBA redim preserve command.
Finally we assign a command button (and later an icon) to run the macro once the user clicks it.
Aside from this, you will also learn how to debug your macros by stepping into the VBA code and using the locals window. You also learn about VBA's object library and how you can search for specific objects to learn which methods, properties and events are associated with them.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/list-box-to-print-multiple-sheets-excel-vba/
LINKS to related videos - Excel ActiveX Combo Box to Select Sheets with VBA: https://rumble.com/v2u8htm
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/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 #ExcelVBA #LeilaGharani
-
LIVE
Revenge of the Cis
2 hours agoEpisode 1449: Boo This
1,961 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!
51 watching -
LIVE
John Crump Live
4 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
130 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
277 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 -
1:56:29
The Quartering
5 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
66.8K28 -
37:08
Standpoint with Gabe Groisman
22 hours agoDOGE The UK?! With Liz Truss
26.5K12