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

[@thwbn3993]

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

[@WiseOwlTutorials]

Thank you so much!

[@krn14242]

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

[@WiseOwlTutorials]

Thanks Kevin!

[@markbocsor3704]

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

[@WiseOwlTutorials]

My pleasure, thanks again for your support!

[@tejamarneni]

Thank you Andrew for the informative video.

[@WiseOwlTutorials]

My pleasure Teja, thanks for watching!

[@RajKumar-on6oh]

Superbly explained! 🙌

[@WiseOwlTutorials]

Thank you Raj!

[@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.

[@WiseOwlTutorials]

Thank you! Happy to hear that you're enjoying the comments as well as the video content. Thank you for watching!

[@wayneedmondson1065]

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

[@WiseOwlTutorials]

Cheers Wayne, glad you enjoyed it and thanks for the comments!

[@hadibq]

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

[@WiseOwlTutorials]

Thanks so much Hadi!

[@shinrafahell]

This is a pretty elegant solution.

[@WiseOwlTutorials]

Thanks Rafael!

[@VillaOuk]

Fabulous trick! Thank you

[@WiseOwlTutorials]

Thanks!

[@Ravi_Singhal25]

Thanks Andrew 🙏

[@WiseOwlTutorials]

A pleasure Ravi!

[@KhalilYasser]

Amazing. Thank you very much.

[@WiseOwlTutorials]

You're very welcome Yasser, thanks for watching!

[@manuelketisch3752]

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?

[@WiseOwlTutorials]

Thanks Manuel! I'm afraid that I don't have an estimate for when we'll have a video on ListViews but that topic is on the To Do list!

[@缺口-q2z]

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?

[@WiseOwlTutorials]

It's tricky because when you're stepping through the procedure it appears as though you only have one copy of the program running when, in reality, you have two. You can see this by choosing View | Call Stack from the VB Editor menu when you're stepping through the code. The Boolean flag ensures that the second copy of the procedure (which is triggered by programmatically changing the value of the list box option) exits but the first copy can continue processing the loop. I hope that helps!

[@amrshehata9840]

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

[@ahmedfreelancer3010]

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.

[@WiseOwlTutorials]

Hi Ahmed! The Find method doesn't allow multiple criteria. You could try using advanced filter if you're working with a list/table.

[@ahmedfreelancer3010]

@@WiseOwlTutorials thanks for your help

[@WiseOwlTutorials]

@@ahmedfreelancer3010 No problem!

[@SeyhaphonTun]

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

[@WiseOwlTutorials]

I'm sorry I don't know!

[@laptopasus121]

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

[@WiseOwlTutorials]

Hi! We have a few videos on using VBA to copy data from Excel to PowerPoint. You can search for these from our channel homepage, I hope it helps!

[@imranbhatti8580]

Mesmorising.

[@WiseOwlTutorials]

:D thanks Imran!