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.
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.
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, 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?
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, 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 ?
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.
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.
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 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.
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
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.
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 :(
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.
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!
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.
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!
Best vba channel I came across just amazing
wow - thanks
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!
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!
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.
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.
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
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 very much for detailed tutorial. nice pace too
Glad you liked it
Thanks Pamai. This is super useful
You're very welcome!
Thanks for sharing your knowledge and experience.
My pleasure!
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 ?
Thanks Pamai. Nice work
You're welcome
Excellent as usual. I have seen most of it from prior publish. Thanks
Awesome! Thank you!
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
another incredible video thank you so much sir!
Glad you enjoyed it!
This is mind blowing. Is this available for access too?
Yes
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
Another great tutorial. Keep it up
Thank you! Cheers!
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
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.
Can we have filter in the listview similar to access listview
You will have to create a custom filter.
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
Very helpful tutorials. Keep going
Thanks a ton
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
thanks for useful video!
You're welcome!
بارك الله فبك
thanks for visit
Great review
thanks!
Does listview control works on MAC for excel??
unfortunately I am not Mac user. Please try posting in stackoverflow
thank you so much
Welcome 😊
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.
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
how to autoresize column width in listview ?? PLs share VBA code
this may help stackoverflow.com/questions/34138226/excel-vba-auto-resize-listview-columns
Can we make icons clickable to access on other page in multi-page
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
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
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
Can u make a tutorial that the icon in list view is clickable?
thanks for suggestions. I'll review it
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
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
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
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
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.
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
This fantastic
thanks!
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
Btw, thank you so much
No problem!
thanks so much !
You're welcome!
Thanks 🥰
You’re welcome 😊
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!
Thanks
you're most welcome!
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
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
why do I feel so stupid? :(
Why :) ?