Wise Owl Answers - How do I add a Select All option to a VBA list box?
Published at : October 16, 2021
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video explains how to add a select all option to a listbox on a user form. Most importantly, you'll see how to avoid triggering an endless cascade of events!
Chapters
00:00 The Question and Basic Form Setup
03:45 The List Box Change Event
04:58 Detecting the Selected Item
07:51 Looping Through List Box Items
10:12 Cascading Events
12:30 Toggling the Change Event
16:51 Inverting the Selection
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video explains how to add a select all option to a listbox on a user form. Most importantly, you'll see how to avoid triggering an endless cascade of events!
Chapters
00:00 The Question and Basic Form Setup
03:45 The List Box Change Event
04:58 Detecting the Selected Item
07:51 Looping Through List Box Items
10:12 Cascading Events
12:30 Toggling the Change Event
16:51 Inverting the Selection
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!
wise owlonline trainingfree training