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.
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?
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?
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.
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. ua-cam.com/play/PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p.html&pbjreload=102
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
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
Try posting in msdn or stackoverflow experts there will be able to assist sooner. please check if this video helps under work objects better. ua-cam.com/video/RQgOxv6nrE0/v-deo.html
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,
Excellent as always, learned many out of box functionality
Thanks
Nice work Pamai. Thanks for making many projects available for free
My pleasure 😊
Another excellent tutorial thank you so much Pamai
Any time!
Thanks for another practical video
You are welcome!
Sir your videos are very relevant. Keep going thanks
Thank you, I will
Thank you for very informative tutorials.
Glad it was helpful!
Great teaching video. Thanks!
You are welcome!
Nicely put together. Keep it up cheers!
Thank you! Cheers!
brilliant as always
Glad you enjoyed it
Keep up the good work. Many thanks
Thanks, will do!
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.
Very creative 🙂 Thanks 🙏
Thank you! Cheers!
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?
Sorry, the short answer is no you can't align individual columns.
try ListBox
Another good one. Thanks!
Thank you too!
👍👍 extremely helpful and relevant. Many thanks
You're very welcome!
Awesome as usual, thanks...
My pleasure!
Outstanding !
Many thanks!
Thanks for very informative tutorials.
Please demonstrate how to pull this list from database instead of excel? Thanks in advance
Great suggestion!
thanks for another amazing video
Glad you enjoyed it
Excelente video
thank you!
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?
great work thanks!
You're welcome!
Hi There!!!, Great vídeos. Quesitos???,
Can you send multiple emails from a listview or a listbox of a userform?
Yes you can! check out below for email automation related videos.
ua-cam.com/play/PLo0aMPtFIFDprmb4MBozLAdCn3-1cnnDA.html
Nice video
Thanks
Is it possible to change the background clolor of listsubitem rows as mod 2
There is no back color property however you can set background using picture property
thanks!
Welcome!
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.
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.
ua-cam.com/play/PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p.html&pbjreload=102
@@VBAA2Z Thanks Lung. 👌
no probs.
How to select list box from keyboard button once list box is shown below text box.
Up Down Arrow key
Space key to select
@@VBAA2Z I tried it did not select
@@sensational4459 ensure properties multiselect is set to 1-fmMultiSelectMulti
❤️👍👍👍👍👍👍
👍👍
@@VBAA2Z can you plz check your email i sent you🙏🌹
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
transparent feature would have been great.
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
Try posting in msdn or stackoverflow experts there will be able to assist sooner.
please check if this video helps under work objects better. ua-cam.com/video/RQgOxv6nrE0/v-deo.html
👍
👍👍
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,