Working with ListView Control in Excel VBA
Вставка
- Опубліковано 4 гру 2020
- Advanced VBA. Working with ListView Control in Excel VBA
Please like, share and comment to improve channel algorithm
👉 Subscribe to receive our latest content ua-cam.com/users/VBAa2z?sub_confirm...
Useful Ready to use VBA Functions: vbaa2z.blogspot.com/2021/04/u...
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ua-cam.com/users/vbaa2zplaylists
Videos: ua-cam.com/users/vbaa2zvideos
#VbaA2z - Наука та технологія
Very useful video and nicely explained. Thanks! I am using VBA for almost 4 years now and I didn't know about Listview control until today. Information regarding Imagelist was a bonus. Thanks again!
Glad it was helpful!
Your contribution to VBA community is commendable. Keep up the good work
Much appreciated!
Fantastic. ListView was the perfect control element I was looking for. (Combobox so limited!)
This presentation was great to get up and going. Very well presented as a starter.
Now to crack column sorting...
Great, informative video.
Glad it was helpful!
Great work! This is very informative. I'm going to watch all your videos from the start of your channel! Thank you for sharing your knowledge!
Awesome, thank you!
Hi Sir Pamai, from a reply to a comment, I gathered you are Indian, that's nice, your English is really good and doesn't have heavy Indian accent. Keep it up Sir, your VBA tutorials are very useful.
Hi Dovac, thanks for your kind words and I'm glad you find them useful.
Thanks for the vids Lung.
As always they are informative and the end product looks professional.
You're welcome Mils. Glad you like them!
thank you very much for detailed tutorial. nice pace too
Glad you liked it
Excellent as usual. I have seen most of it from prior publish. Thanks
Awesome! Thank you!
Sir, thank you so much! Very helpful even for earlier versions for excel. This control turns out to be an unexpectedly powerful one! Very often i have to populate listboxes from collections of classes. The weak point of the listbox is that the only way to fill listbox column headers is when you get data from sheet range as data source - it is not possible when you get data from elsewhere. The wokaround was to create additional listbox for fields - not very nice. With listview it seems that this tricky point is fixed! Also, the user can change the column width if needed!
Glad you found it useful. Thanks for watching.
Thanks for sharing your knowledge and experience.
My pleasure!
Best vba channel I came across just amazing
wow - thanks
Thanks Pamai. This is super useful
You're very welcome!
with the formatting of numbers it seems to be a bit difficult in the listview-Box: partly the Excel formatting is working, partly it's not (colors, the whitespace-width "_)" in Excel) - which leads to closing brackets in your listview when numbers are positive. This made me check the video several times to realise, what's the problem...
Anyhow, I learned a lot! Still I miss the opportunity to add multiple checkboxes in the listview - will need some work-arounds with images, I guess.
Thanks a lot for your efforts and stay on!
Thank you for the fantastic ListView video. Would solve how to get sheet information and display it logically on the userform. Your videos are inspirational.
Glad to hear. Thanks for watching!
Another great tutorial. Keep it up
Thank you! Cheers!
another incredible video thank you so much sir!
Glad you enjoyed it!
Thanks Pamai. Nice work
You're welcome
Very helpful tutorials. Keep going
Thanks a ton
thanks for useful video!
You're welcome!
Great review
thanks!
بارك الله فبك
thanks for visit
thanks so much !
You're welcome!
thank you so much
Welcome 😊
Thanks 🥰
You’re welcome 😊
This fantastic
thanks!
Btw, thank you so much
No problem!
Thanks
you're most welcome!
Thank you, this is very useful!
I came across the issue of not being able to sort numeric values in Listviews. Is there a work around you'd recommend?
I normally stage data in Sheet or Array and sort them and then populate them
@@VBAA2Z ok thanks. I’ll try that
Hi
Sorry, I could not properly listen to your name, but you are really awesome. Your VBA tutorials are far different from the other people teaching VBA. Can you please make a tutorial on creating Listgrid view as another VBA Expert (JKP) has created (i.e.hierarcicle )
Hi Imran, I'm Lung Pamai :) thanks for your kind works
I'll try and cover Listgrid too in future videos
Nice name. Sounds Chines.
I would wait for ListGrid Video.
Sir,
I am using MS Office 2016 now.but the problem is that there is no Listview & Date picker option in the userform.
I got Mscomtct2.ocx and Mscomctl from internet. I downloaded and installed the ocx file, after that there is Listview and Date picker file missing. how to solve ?
Can we make icons clickable to access on other page in multi-page
This is mind blowing. Is this available for access too?
Yes
Hi Lung
This control is nice with a lot of addtional feature over a ListBox, but sadly we cannot load data to it in one go as we can for ListBox i.e. ListBox1.List = arData (single/multidimensional). Isn't it?. But good for a smaller dataset I think.
listview has RowSource property there should be a way to set this up perhaps creating an class / object
Hope you would also create maybe a shorter video to load data to such controls in one go instead of looping.
sure, I'll try it out and come back
Thanks, very helpful. Just one question regarding min 3:15 when you show userform2. It seems that every “cell” of the list view allows multiple lines. How do you implement that function?
that's the inbuilt feature
Hello, thank you so much for this video, I am having a problem and I hope you can help me, when I insert the small icons to control the height of the rows it shows a blank space in the first column, how do I prevent this from happening
You're most welcome.
Make sure your source has data or icon is valid image type. Feel free to comment your code here.
Can we have filter in the listview similar to access listview
You will have to create a custom filter.
How to select n focus to a perticular list row in listview?
Hi Hemant, try something like this.
ListView1.SetFocus
ListView1.ListItems(2).Selected = True
ListView1.ListItems(3).EnsureVisible
If we use ListView control in a file and gives it to client, does client needs to install the Listview control as well on their machine?
You clients may have to install common controls
how to autoresize column width in listview ?? PLs share VBA code
this may help stackoverflow.com/questions/34138226/excel-vba-auto-resize-listview-columns
Sir, thanks............need more HELP on this listview,
Like how to filter data with multiple criteria,
how to add images infront of all employee name,
sort coloums with both type numerical or alphabetical
Best filter it from source or to keep it simplified you can your sorting keys created and have data loaded to array to prevent requiring data.
Other videos which might help. ua-cam.com/video/0TqlbXZyE3U/v-deo.html
@@VBAA2Z dear sir waiting for more videos on listview
Thank you so much for sharing. I have a query . I am unable to format value into USD and another currency it converted only $#,##0.00.Could you please tell us how we format this type of currency. Requesting you to please make a video where we can sort A-Z and Small to Large it is possible to sort data.
What is the format you want to set?
For sort it is best to load all data to array and sort it on runtime or sort it from source itself.
@@VBAA2Z USD
Hi. your tutorials are very informative. I would like to have your version of Windows 7. Could you send me a link to download. Thank you.
Windows7 Ultimate.
@@VBAA2Z Thanks
Sir, is it possible to use 2 Database (or sheet) and then show those 2 Data to one list view (listview1)?
yes you can. You can join 2 tables or link sheets using lookup/index(Match
Can u make a tutorial that the icon in list view is clickable?
thanks for suggestions. I'll review it
How to apply adv filter on list view plz help
I'd suggest filter based on user input to sheet and reload the filtered data
Is it possible to get data from sql server and will shown in listview in vba?
Yes, please check below video links
ua-cam.com/video/iTUTbonCDNs/v-deo.html
ua-cam.com/video/U1sQ1-Oa0fs/v-deo.html
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
Does listview control works on MAC for excel??
unfortunately I am not Mac user. Please try posting in stackoverflow
MS Listview may not be accessible on every client... and Version Number makes it easily incompatible. Or am I wrong?
There could be compatibility issues.
Check this video: ua-cam.com/video/QGZqjUGhJ1Q/v-deo.html
How to add and activate control imagelist vba excel in office 365 64 bits in windows 10 64 bits
Please check here.
ua-cam.com/video/QGZqjUGhJ1Q/v-deo.html
Hello , in 16:10 is there a way to add checkbox on a specifix column ? i just add this line :
With MENU.ListView2
.CheckBoxes = True
.ColumnHeaders(1).position =5
End With
Didn't work, only first column work :(
Yes, as discussed in video only first column can hold checkbox however you can move columns to desired location.
@@VBAA2Z Thanks, but i think i have a bug : it writes me "position" instead of "Position"...
try and recheck if position itself is name of variable in your project.
@@VBAA2Z got it : it was a bug , fixing when i start a new userform and listview 😉
ok great!
Can you please point me in the direction of how to add data FROM a listview to a database?
I have been struggling for a couple days and cannot find anything online to get me going in the right direction.
I am trying to add ALL column and row data. The listview has multiple columns and rows that I want to add to the Microsoft Sequel database.
I would be very appreciative of your assistance.
This is a good tutorial as far as reading, writing to and from Listview.
Once you're able to do that, check this videos to learn how to write to database ua-cam.com/video/82IabW5_mao/v-deo.html
@@VBAA2Z I am able to read and write to and from database with listview. The problem I have is when I try writing all the items to the database at one time…I only get the first item in the listview to write to db multiple times, same data not the second,third etc row data.
I’m sure it has to do with items and su items but just can’t sort it out. I’ve watched all your vids on this, they are great info.
Hi,
How to install listview on my pc if there is not available on my PC ??????
please refer to this video
ua-cam.com/video/QGZqjUGhJ1Q/v-deo.html
How to add and open hyperlink in ListView in VBA EXCEL ??? Can you help me with your sample code, video clip, or training course to solve this problem?
this may help - pamaitech.com/add-a-hyperlink-in-a-listview-control-when-an-item-is-clicked/
@@VBAA2Z thank you so much for help me.
Hi VBA A2Z, could you help me how to verify if no item is selected in a LV?
Please try below
LV.SelectedItems.Count > 0
@@VBAA2Z Already tried, but LV.SelectedItemS doesn't exist
Can you help me with my task?
sure happy to guide you
You should start this video with a HUGE WARNING about how this is useless for 64-bit Office!
I have not been able to use ListView for more than 10 years because of this MS Fuckup.
This video is demo on Office 365, 64 Bit Excel.
ua-cam.com/video/QGZqjUGhJ1Q/v-deo.html
why do I feel so stupid? :(
Why :) ?
Fantastic, Outstanding !!!!
But i am facing one issue in li.subitems.add
I am getting ... li.add.subitems .... Please Assist ... Thank you
Feel free to commend you code and error