Working with ListView Control in Excel VBA 

Your contribution to VBA community is commendable. Keep up the good work

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!

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.

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.

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!

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.

Best vba channel I came across just amazing

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!

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!

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 )

Thanks for the vids Lung. As always they are informative and the end product looks professional.

thank you very much for detailed tutorial. nice pace too

Excellent as usual. I have seen most of it from prior publish. Thanks

Thanks Pamai. This is super useful

Thanks for sharing your knowledge and experience.

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 ?

Another great tutorial. Keep it up

another incredible video thank you so much sir!

thank you so much

This is mind blowing. Is this available for access too?

Thanks Pamai. Nice work

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.

thanks for useful video!

Very helpful tutorials. Keep going

بارك الله فبك

This fantastic

Great review

Btw, thank you so much

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?

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

Sir, is it possible to use 2 Database (or sheet) and then show those 2 Data to one list view (listview1)?

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?

Is it possible to get data from sql server and will shown in listview in vba?

how to autoresize column width in listview ?? PLs share VBA code

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?

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.

Thanks

Can we make icons clickable to access on other page in multi-page

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

Can we have filter in the listview similar to access listview

Does listview control works on MAC for excel??

MS Listview may not be accessible on every client... and Version Number makes it easily incompatible. Or am I wrong?

How to apply adv filter on list view plz help

Can u make a tutorial that the icon in list view is clickable?

thanks so much !

Hi, How to install listview on my pc if there is not available on my PC ??????

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?

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 :(

Fantastic, Outstanding !!!! But i am facing one issue in li.subitems.add I am getting ... li.add.subitems .... Please Assist ... Thank you

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.

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

Thanks 🥰

How to select n focus to a perticular list row in listview?

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.

Hi VBA A2Z, could you help me how to verify if no item is selected in a LV?

How to add and activate control imagelist vba excel in office 365 64 bits in windows 10 64 bits

Can you help me with my task?

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.

why do I feel so stupid? :(