Working with ListBox Control in Excel VBA

[@holieh5301]

Nice work Pamai. Thanks for making many projects available for free

[@VBAA2Z]

My pleasure 😊

[@roland9923]

Excellent as always, learned many out of box functionality

[@VBAA2Z]

Thanks

[@adrianl6409]

Another excellent tutorial thank you so much Pamai

[@VBAA2Z]

Any time!

[@hoseal8048]

Thanks for another practical video

[@VBAA2Z]

You are welcome!

[@MuhammadShahAlam99]

Good Job👍 Suppose, we took another column (Remarks column) and took a TextBox. After selecting 8-9 data from the Listbox, whatever I write in the textbox will be added to that column.

[@SaraPerzYT]

Sir your videos are very relevant. Keep going thanks

[@VBAA2Z]

Thank you, I will

[@Jusils]

Thank you for very informative tutorials.

[@VBAA2Z]

Glad it was helpful!

[@m-squaredcontractors9720]

Thank you for the great tutorial. I have a question not sure if you covered that in your other tutorials. How do I align data on a 2 column listbox for example left align column 1 and right align column 2?

[@VBAA2Z]

Sorry, the short answer is no you can't align individual columns. try ListBox

[@scottansir7708]

brilliant as always

[@VBAA2Z]

Glad you enjoyed it

[@gregorytaylor2749]

Great teaching video. Thanks!

[@VBAA2Z]

You are welcome!

[@kinga334]

Keep up the good work. Many thanks

[@VBAA2Z]

Thanks, will do!

[@matnz7546]

Thanks for very informative tutorials. Please demonstrate how to pull this list from database instead of excel? Thanks in advance

[@VBAA2Z]

Great suggestion!

[@kingsoko5319]

Very creative 🙂 Thanks 🙏

[@VBAA2Z]

Thank you! Cheers!

[@carlo9567]

Outstanding !

[@VBAA2Z]

Many thanks!

[@sunnylokesh3500]

👍👍 extremely helpful and relevant. Many thanks

[@VBAA2Z]

You're very welcome!

[@pekidonn5139]

Nicely put together. Keep it up cheers!

[@VBAA2Z]

Thank you! Cheers!

[@davidvyskocil9132]

Awesome as usual, thanks...

[@VBAA2Z]

My pleasure!

[@luiscarlosbermudezjaramill5842]

Excelente video

[@VBAA2Z]

thank you!

[@wennychez5606]

Another good one. Thanks!

[@VBAA2Z]

Thank you too!

[@efernandes67]

Excellent tutorial Pamai. Can you tell me if its possible to have triple state on a listbox with a MultiSelect = fmMultiSelectMulti and ListStyle = fmListStyleOption? If not how can it be done?

[@lchewang6512]

thanks for another amazing video

[@VBAA2Z]

Glad you enjoyed it

[@HarshlyHarshly-fs9sn]

great work thanks!

[@VBAA2Z]

You're welcome!

[@haider236]

Is it possible to change the background clolor of listsubitem rows as mod 2

[@VBAA2Z]

There is no back color property however you can set background using picture property

[@excel2kit]

Nice video

[@VBAA2Z]

Thanks

[@jaredkulavich6081]

thanks!

[@VBAA2Z]

Welcome!

[@sensational4459]

How to select list box from keyboard button once list box is shown below text box.

[@VBAA2Z]

Up Down Arrow key Space key to select

[@sensational4459]

@@VBAA2Z I tried it did not select

[@VBAA2Z]

@@sensational4459 ensure properties multiselect is set to 1-fmMultiSelectMulti

[@lordkailon]

Hi There!!!, Great vídeos. Quesitos???, Can you send multiple emails from a listview or a listbox of a userform?

[@VBAA2Z]

Yes you can! check out below for email automation related videos. kzbin.info/aero/PLo0aMPtFIFDprmb4MBozLAdCn3-1cnnDA

[@Husky_Passion]

the very bad thing with listbox, is they cannot be made transparent, they nearly show as if a frame and it's super anoying to make a transparent list. Couldn't find an api to do it, so usually i use a textbox but it's super anoying to simulate a listbox

[@VBAA2Z]

transparent feature would have been great.

[@debbie6085]

Thanks Lung. Great video. I looked for the link to download the source code but couldn't determine which one related to this video. Can you please advise which one is for this? Also, what's the link for the first video? I'd like to watch it. Thanks.

[@VBAA2Z]

Thanks Debbie. I will try to add links to Project ID going forward. For now, if you just need source code for this episode you can go with Project ID: 011. Else for all videos bundled go for Project ID - 010 UI UX UserForm - Series Package - All Episodes (1-18) Playlist. kzbin.info/aero/PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p&pbjreload=102

[@debbie6085]

@@VBAA2Z Thanks Lung. 👌

[@VBAA2Z]

no probs.

[@anhnhatnguyet4628]

I have a word file of 300 pages. every 3 pages will be 1 section (pages 1 to 3, 4 to 6, 7 to 9, .....). now I want to use vba to print each section so that when printing, each section contains 3 pages. that is, page 4 is not merged on page 3 for 2-sided printing. same for page 7 and page 6. page 10 and page 9 ..... hope you support me

[@VBAA2Z]

Try posting in msdn or stackoverflow experts there will be able to assist sooner. please check if this video helps under work objects better. kzbin.info/www/bejne/iILKgKusa9Ole5I

[@Kumaranmoljha]

I have a macro enabled worksheet which saves the data as XML format using mail merge .Then i import the XML file in Tally manually with import data option. Now i am looking for a solution which would make the process automatic using Tally (“localhost:9000”) i.e. once i save the file as XML format, immediately the data should get imported in Tally without any manual process. Hope i explained my query properly. Thanks in Advance. Best Regards,

[@atingnewmai3680]

👍

[@VBAA2Z]

👍👍

[@redhaakhund1271]

❤️👍👍👍👍👍👍

[@VBAA2Z]

👍👍

[@redhaakhund1271]

@@VBAA2Z can you plz check your email i sent you🙏🌹