Working with ListView Control in Excel VBA

[@jmathew6988]

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!

[@VBAA2Z]

Glad it was helpful!

[@holieh5301]

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

[@VBAA2Z]

Much appreciated!

[@dovacmarlon7493]

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.

[@VBAA2Z]

Hi Dovac, thanks for your kind words and I'm glad you find them useful.

[@kingsoko5319]

Best vba channel I came across just amazing

[@VBAA2Z]

wow - thanks

[@garylyons7958]

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.

[@VBAA2Z]

Glad it was helpful!

[@KevinAanensen]

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.

[@VBAA2Z]

Glad to hear. Thanks for watching!

[@dwsteyl]

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!

[@VBAA2Z]

Awesome, thank you!

[@rainerstahl610]

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!

[@dipankarroy5529]

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 ?

[@aNDy-qh1em]

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!

[@VBAA2Z]

Glad you found it useful. Thanks for watching.

[@imranbhatti8580]

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.

[@VBAA2Z]

listview has RowSource property there should be a way to set this up perhaps creating an class / object

[@imranbhatti8580]

Hope you would also create maybe a shorter video to load data to such controls in one go instead of looping.

[@VBAA2Z]

sure, I'll try it out and come back

[@kinga334]

Thanks Pamai. This is super useful

[@VBAA2Z]

You're very welcome!

[@imranbhatti8580]

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 )

[@VBAA2Z]

Hi Imran, I'm Lung Pamai :) thanks for your kind works I'll try and cover Listgrid too in future videos

[@imranbhatti8580]

Nice name. Sounds Chines.

[@imranbhatti8580]

I would wait for ListGrid Video.

[@nicolocascone8842]

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?

[@VBAA2Z]

that's the inbuilt feature

[@matnz7546]

Thanks Pamai. Nice work

[@VBAA2Z]

You're welcome

[@kuksten1579]

thank you very much for detailed tutorial. nice pace too

[@VBAA2Z]

Glad you liked it

[@adrianl6409]

Thanks for sharing your knowledge and experience.

[@VBAA2Z]

My pleasure!

[@praveendhanasekar2555]

Can we have filter in the listview similar to access listview

[@VBAA2Z]

You will have to create a custom filter.

[@Brad-fh2vn]

another incredible video thank you so much sir!

[@VBAA2Z]

Glad you enjoyed it!

[@abuabdullah2738]

Respected Sir, I watched your video and it was very helpful to me. You explain things very well. Sir, I am facing an issue in the list view. I have data in Hindi, but when I bring it into the list view, question marks (????) appear. If there is any solution, please let me know.

[@FitnFabulousLife]

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?

[@VBAA2Z]

You clients may have to install common controls

[@hoseal8048]

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

[@VBAA2Z]

Awesome! Thank you!

[@mrnimbus2556]

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

[@VBAA2Z]

Yes, please check below video links kzbin.info/www/bejne/n4W4hZWlo6h3hNU kzbin.info/www/bejne/i2LWgmRjhMZjnNU

[@roland9923]

Another great tutorial. Keep it up

[@VBAA2Z]

Thank you! Cheers!

[@ekilunewmai7033]

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

[@VBAA2Z]

Yes

[@sallu21m]

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

[@VBAA2Z]

this may help stackoverflow.com/questions/34138226/excel-vba-auto-resize-listview-columns

[@FitnFabulousLife]

Does listview control works on MAC for excel??

[@VBAA2Z]

unfortunately I am not Mac user. Please try posting in stackoverflow

[@AKSHAYKUMAR-kh3oj]

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

[@stefanogattoCH]

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?

[@VBAA2Z]

I normally stage data in Sheet or Array and sort them and then populate them

[@stefanogattoCH]

@@VBAA2Z ok thanks. I’ll try that

[@benjaminf5731]

thank you so much

[@VBAA2Z]

Welcome 😊

[@arikurita401]

thanks for useful video!

[@VBAA2Z]

You're welcome!

[@amorbatna2725]

بارك الله فبك

[@VBAA2Z]

thanks for visit

[@hasbihadirahmanputra5340]

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

[@VBAA2Z]

yes you can. You can join 2 tables or link sheets using lookup/index(Match

[@sunnylokesh3500]

Very helpful tutorials. Keep going

[@VBAA2Z]

Thanks a ton

[@otealiig5592]

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

[@VBAA2Z]

Feel free to commend you code and error

[@anandchaudhari901]

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

[@VBAA2Z]

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. kzbin.info/www/bejne/ZoXUnZWOj954abc

[@anandchaudhari901]

@@VBAA2Z dear sir waiting for more videos on listview

[@mohammedalsarraj9963]

Great review

[@VBAA2Z]

thanks!

[@brainservice6863]

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.

[@VBAA2Z]

Windows7 Ultimate.

[@brainservice6863]

@@VBAA2Z Thanks

[@rjdexceltutorial4986]

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

[@VBAA2Z]

thanks for suggestions. I'll review it

[@kailashsoni676]

How to apply adv filter on list view plz help

[@VBAA2Z]

I'd suggest filter based on user input to sheet and reload the filtered data

[@ahmedzakaria11]

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

[@VBAA2Z]

please refer to this video kzbin.info/www/bejne/h3i9op2LfM19Z7M

[@besirozmen3733]

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

[@VBAA2Z]

You're most welcome. Make sure your source has data or icon is valid image type. Feel free to comment your code here.

[@ApprendreavecJADDI2023]

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?

[@VBAA2Z]

this may help - pamaitech.com/add-a-hyperlink-in-a-listview-control-when-an-item-is-clicked/

[@ApprendreavecJADDI2023]

@@VBAA2Z thank you so much for help me.

[@hemantjshah]

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

[@VBAA2Z]

Hi Hemant, try something like this. ListView1.SetFocus ListView1.ListItems(2).Selected = True ListView1.ListItems(3).EnsureVisible

[@levelupexcelskill]

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.

[@VBAA2Z]

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.

[@levelupexcelskill]

@@VBAA2Z USD

[@brenthalbach3645]

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.

[@VBAA2Z]

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 kzbin.info/www/bejne/bmOskpWNasSgl9E

[@brenthalbach3645]

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

[@alessandrolazzarini270]

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

[@VBAA2Z]

Please try below LV.SelectedItems.Count > 0

[@alessandrolazzarini270]

@@VBAA2Z Already tried, but LV.SelectedItemS doesn't exist

[@lollo4711]

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

[@VBAA2Z]

There could be compatibility issues. Check this video: kzbin.info/www/bejne/h3i9op2LfM19Z7M

[@ApprendreavecJADDI2023]

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

[@VBAA2Z]

Please check here. kzbin.info/www/bejne/h3i9op2LfM19Z7M

[@SuangSuanglee-vn2qr]

This fantastic

[@VBAA2Z]

thanks!

[@tinhnguyen08]

thanks so much !

[@VBAA2Z]

You're welcome!

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

[@ekilunewmai7033]

Btw, thank you so much

[@VBAA2Z]

No problem!

[@sefaelmas8501]

Thanks 🥰

[@VBAA2Z]

You’re welcome 😊

[@alializadeh8195]

Thanks

[@VBAA2Z]

you're most welcome!

[@coolag74]

Can you help me with my task?

[@VBAA2Z]

sure happy to guide you

[@byteseq]

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.

[@VBAA2Z]

This video is demo on Office 365, 64 Bit Excel. kzbin.info/www/bejne/h3i9op2LfM19Z7M

[@limitone9564]

why do I feel so stupid? :(

[@VBAA2Z]

Why :) ?

[@TSHORYUKEN]

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

[@VBAA2Z]

Yes, as discussed in video only first column can hold checkbox however you can move columns to desired location.

[@TSHORYUKEN]

@@VBAA2Z Thanks, but i think i have a bug : it writes me "position" instead of "Position"...

[@VBAA2Z]

try and recheck if position itself is name of variable in your project.

[@TSHORYUKEN]

@@VBAA2Z got it : it was a bug , fixing when i start a new userform and listview 😉

[@VBAA2Z]

ok great!