Wise Owl Answers - How do I add a Select All option to a VBA list box?

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:

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

[krn]

Great answer to Mark's question. Well done Sir.

[thwbn]

You make VBA great again! Every single time, every single video!

[tejamarneni]

Thank you Andrew for the informative video.

[markbocsor]

Thanks Andrew this answered my question perfectly:-) Again an amazing video

[MyAudioBookCompilation]

Just by reading all the comments for each video you make makes me smile already 😁 You have created a community of your own sir. Keep safe always.

[hadibq]

Thanks Andy! Love your tutorials. cheers for the efforts of learning and teaching the proper way!

[wayneedmondson]

Awesome Andrew! Thanks for another great VBA lesson :)) Thumbs up!!

[manuelketisch]

Very nice solution, thanks for sharing!

May i ask when we can expect a video on how to populate ListViews with ADODB from a closed excel table as data source?

[缺口-qz]

Thanks for the tutorial. This is exactly what I needed. However, I got lost when the ChangeEventDisabled Boolean variable is true, then the Exit Sub would be executed so why it still goes to the next i ? Could you please clarify a bit more?

[amrshehata]

Hello
Thanks for all information we got it from your simply videos
But i need help
How can i create journal entry form that includes date JV number and narration ( description) then in the next frame in the same form i need to design row including account number, account name, narration ( same the first narration and its accept editing ), debit, credit .
Then we can add more rows same which i need in the above after than i need to add two cells or text box for calculate the debit column and credit column To adjust the journal entry
Thanks for your help

[ahmedfreelancer]

Andrew you make amazing video's
My question is how I can use find in vba excel for search on multiple criteria if it's possible.

[laptopasus]

Hello sir, can you teach me how to make data merge from excel to powerpoint like video WatchData?

[SeyhaphonTun]

can listbox disabled to select but allow to scroll by vba code ?