Wow! Hats off! You’re a legend! That’s an awesome add-in! It’s amaizing and so usefull - Frankly, it should be a part of Excel VBA controls. I cannot stress enough how much effort and time you’ve put in that tool develpoment and cannot thank you enough for sharing that with us. I’m looking forward to getting deep in the code of the tool.
Wow. Thank you for this amazing work. I have an Excel bookkeeping application, and I needed to be able to research easily and sort transactions and invoices. This has made it easy because there is no need for coding.
I had to build a similar thing because working with traditional listbox didn't meet project requirements. Yours is definitely more elegant and functional. Thank you for sharing the source code so we can learn a couple of new tricks. By the way, it would be awesome if you could expand on the With Events declaration in one of your future videos! Thanks again Paul.
First he was the array class and now this, what's next treeviews? Simply amazing! I can't tell you how much your content has helped me, thank you very much Paul!
Paul, you are an absolute genius... Thank you so much, it's truly a brilliant add-in that I will definitely use very often!!! Best regards, Piotr Sikorski.
Recently needed to start using vba. I'm very out of practice. The language I'm best at is R, and I have to say that you teach in such a brilliant way I can make sense of it like if as if I was using R. You literally are one of the most brilliant VBA educators. I deeply appreciate your dedication to this channel. I may get your course in the future, however if you ever make a book (or have made one already) I would love to buy one. Video courses are great but a book is so dependable and convenient for at work/offline reference, learning styles, etc etc. But anywho, your channel is amazing.
This is absolutely excellent! Bravo to you. If I could do that, I would be so happy (and proud). Let me dream. I will study this modern listbox. Thank you very much for this great work.
Great work done and many thanks for sharing. How can I align text in the columns? I have tried different ways but it is not working. Can you please help me?
Excelente professor aprendi muito com os vídeos do canal não sei falar inglês 😅 então para eu poder assistir os vídeos uso um narrador do Google. Valeu professor tmj
Please sell it at a price, Paul. Your efforts shouldn’t go free. And please also expand this into something like VBFlexGrid with RGB colour support and also implement TreeView. Please save us from MS’s shutdown of ActiveX controls! If you can do this, you can also do it with Grid/Tree etc. Thank you. Suggested selling not because of monetary reward but to recognise the hours and effort you’ve spent for this. I hope you can set a reasonable price unlike others…
This awesome! I have a project based on VBA in which I use a list but data is not on a sheet, instead is passed by a dictionary to the list box as the dictionary holding the data is the result of many functions passing result to my final class. I wonder how should I implement your class on my project. You have done a nice work, I will take a look to see how I can include it in my project.
Should this work on Excel 365 for Mac? It reported an error on installation. If not, is it possible to look at the source code to see if it can be adapted for Mac?
A great solution! Thanks for sharing! One question - I use Excel solutions heavily, because there is no need to install anything on the computers to use them. And as I work in an educational field we have hundreds of computers. When I want to use your solution I've to install it as add-in. This limits the functionality for me totally. Is there any other way to use it (like add it to a existing excel solution as a class module,...)? What do you think? Thanks and best regards, Fritz
You do not need to install the Add-In to the Add-In folder to reference and use it. Place it on the network drive and than select it from VBEditor Tools -> References -> Browse.
that is smart! but one question; how could we filter the columns based on their numeric values, for example from the budget column we'd need to show rows between 50,000,000 and 150,000,000 or a filter showing records less than 50,000,000 and greater than 150,000,000 ?
Hello Paul, I'm currently trying to get familiar with your add-in and implement it in my first project, and I believe there's possibly an error in the code with the "Display First" button (runtime error 9). I'm using Office 2024. If you could kindly check that everything is in order with the shared files when you have a moment, I would appreciate it… "Display All" works fine... 🙏
Paul, I noticed there’s an updated version on Dropbox compared to the one released at launch and shown in the video-I downloaded it, and everything works perfectly!!! Once again, hats off to your genius!!!
Hi Paul I was so excited to have this tool, but unfortunately I can't download it. When I click the link, I get a black screen with a flashing circle and the download doesn't start. Could you give me another link to try ? Thank you.
Paul, I've placed the add-in in the Excel add-in folder. But when I OK the add-in dialogue, I get an error "This filetype is not supported in Protected View", Can you please advise .... Thanks
I think this is too much, VBA should not be use for this. I mean, Excel worksheet already has this feature, you can enable filter etc. Unless you create a standalone new windows form application.
"VBA should not be use for this. I mean, Excel worksheet already has this feature" thats a bit contradictory! the worksheet function listbox is linked somewhat to the sheet data Paul's modernlb is driven from an array! "VBA should not be use for this" so why did Microsoft create 2 versions of this a listbox and listview in VBA?
@@geneanthony3421 If you could imagine how many factories, mostly smaller once, are still only using excel and access for managing stock and so on...! I think next 20 years it will still be applied for sure...! And specifically for me it's a kind of retro-programming, just because I grew up with VBA, and I never want to miss this time to be honest. So, out of my view you're sort of disrespectful with VBA and even with the people who are using, not matter why they're using it...! Everything started somewhere...!
@@geneanthony3421 If you could imagine how many factories, mostly smaller once, are still only using excel and access for managing stock and so on...! I think next 20 years it will still be applied for sure...! And specifically for me it's a kind of retro-programming, just because I grew up with VBA, and I never want to miss this time to be honest. So, out of my view you're sort of disrespectful with VBA and even with the people who are using, not matter why they're using it...! Everything started somewhere...!
@@rods6405 I’m not watching, it came up in my feed and I browsed it quickly. I’m saying that it’s odd that VBA is still around, it should be a distant memory by this point
Wonderful! Hats off Paul! you made it so easy and simple for us. Very curious to know what skill and knowledge are required to develop such sophisticated addons. You must have used some components/controls that aren't intrinsic in Excel VBA, isn't it?
Let me know what you think about the Modern Listbox in the comments below 👇
the link is not working ! i can't open the mwebpage to get the file
On first view i am absolutely amazed and cant wait to try it out.
Wow! Hats off! You’re a legend! That’s an awesome add-in! It’s amaizing and so usefull - Frankly, it should be a part of Excel VBA controls. I cannot stress enough how much effort and time you’ve put in that tool develpoment and cannot thank you enough for sharing that with us. I’m looking forward to getting deep in the code of the tool.
Wow. Thank you for this amazing work. I have an Excel bookkeeping application, and I needed to be able to research easily and sort transactions and invoices. This has made it easy because there is no need for coding.
I had to build a similar thing because working with traditional listbox didn't meet project requirements. Yours is definitely more elegant and functional. Thank you for sharing the source code so we can learn a couple of new tricks. By the way, it would be awesome if you could expand on the With Events declaration in one of your future videos! Thanks again Paul.
Thanks for the suggestion.
Brilliant work!
Respect 👏🏼
I salute you Paul for creating a masterpiece, you’ve made our lives simpler. Thank you! 😊
My pleasure!
Amazing add-in thank you for sharing with source code!
First he was the array class and now this, what's next treeviews? Simply amazing! I can't tell you how much your content has helped me, thank you very much Paul!
You're welcome Gabriel
Paul, you are an absolute genius... Thank you so much, it's truly a brilliant add-in that I will definitely use very often!!! Best regards, Piotr Sikorski.
You're very welcome Piotr!
This is what i want from the masters of VBA if Billgates doesnt want to improve VBA then we VBA coders must do it tru like what he does!
Recently needed to start using vba. I'm very out of practice. The language I'm best at is R, and I have to say that you teach in such a brilliant way I can make sense of it like if as if I was using R. You literally are one of the most brilliant VBA educators. I deeply appreciate your dedication to this channel. I may get your course in the future, however if you ever make a book (or have made one already) I would love to buy one. Video courses are great but a book is so dependable and convenient for at work/offline reference, learning styles, etc etc. But anywho, your channel is amazing.
The Excel VBA Handbook course is text based. Check it out here: theexcelvbahandbook.com/
This is absolutely excellent! Bravo to you. If I could do that, I would be so happy (and proud). Let me dream. I will study this modern listbox. Thank you very much for this great work.
Go for it!
Most generous of you! great piece of work. clever!
Boom!!!🎉 Amazing work and so much efforts spent! Thanks Paul!👍👍👍
My pleasure!!
The coolest Listbox so far!!!
Thanks
Great job Paul!
Intrigued to take a look at the inner workings of this.
Thanks Ben
Great work done and many thanks for sharing. How can I align text in the columns? I have tried different ways but it is not working. Can you please help me?
There are some neat features in there, like the pagination,, but honestly, much of this is already covered in the ListView control.
You nailed it. Awesome work. Thank you!
Much appreciated!
And that is why you are a legend!
Thanks😀
This Great man, Tnx a million. I subscribed to your channel just now to learn more from you.
Pretty cool tool! Thank you for sharing!
You're welcome.
How much time did you spend on this? Just curious.
Impressive!!
Excelente professor aprendi muito com os vídeos do canal não sei falar inglês 😅 então para eu poder assistir os vídeos uso um narrador do Google. Valeu professor tmj
Please sell it at a price, Paul. Your efforts shouldn’t go free. And please also expand this into something like VBFlexGrid with RGB colour support and also implement TreeView. Please save us from MS’s shutdown of ActiveX controls! If you can do this, you can also do it with Grid/Tree etc. Thank you. Suggested selling not because of monetary reward but to recognise the hours and effort you’ve spent for this. I hope you can set a reasonable price unlike others…
It's awesome and amazing, great job.
Thank you! Cheers!
This awesome! I have a project based on VBA in which I use a list but data is not on a sheet, instead is passed by a dictionary to the list box as the dictionary holding the data is the result of many functions passing result to my final class. I wonder how should I implement your class on my project. You have done a nice work, I will take a look to see how I can include it in my project.
Glad you like it
Please Make other Add Ins for Userform or Please do some upgrade for your modern listbox in line with the latest ux or ui design right now
one word, "Amazing"
Thanks
Thank you verry match, it is Brilliant.
I'm glad you like it
Should this work on Excel 365 for Mac? It reported an error on installation. If not, is it possible to look at the source code to see if it can be adapted for Mac?
I don't use a Mac but to my knowledge UserForms are not available in recent Mac versions of Excel?
Great and amazing work Paul, respect and kudos to you!
I am testing it, i believe you have to polish it, there are some little bugs in it.
Let me know if you find any bugs. I will update the code accordingly.
@@Excelmacromastery I am now still busy testing it, and i will mail you my findings.
You rock.
Very good thanks. Might give it a test to see if its faster than a listview to load!
Just tested with my music data base 20,000 songs its very fast!
Glad you found it useful.
A great solution! Thanks for sharing!
One question - I use Excel solutions heavily, because there is no need to install anything on the computers to use them. And as I work in an educational field we have hundreds of computers.
When I want to use your solution I've to install it as add-in. This limits the functionality for me totally. Is there any other way to use it (like add it to a existing excel solution as a class module,...)?
What do you think? Thanks and best regards, Fritz
You do not need to install the Add-In to the Add-In folder to reference and use it. Place it on the network drive and than select it from VBEditor Tools -> References -> Browse.
What @tommy704581 said.
@@tommy704581 Thanks for this hint. This will solve my issue.
that is smart! but one question; how could we filter the columns based on their numeric values, for example from the budget column we'd need to show rows between 50,000,000 and 150,000,000 or a filter showing records less than 50,000,000 and greater than 150,000,000 ?
The filter doesn't have that functionality at this time. Creating a filter similar to Excel is a major project by itself.
Hello Paul, I'm currently trying to get familiar with your add-in and implement it in my first project, and I believe there's possibly an error in the code with the "Display First" button (runtime error 9). I'm using Office 2024. If you could kindly check that everything is in order with the shared files when you have a moment, I would appreciate it… "Display All" works fine... 🙏
Paul, I noticed there’s an updated version on Dropbox compared to the one released at launch and shown in the video-I downloaded it, and everything works perfectly!!! Once again, hats off to your genius!!!
I have fixed that issue and one or two others in the latest version.
Hi Paul I was so excited to have this tool, but unfortunately I can't download it. When I click the link, I get a black screen with a flashing circle and the download doesn't start. Could you give me another link to try ? Thank you.
Make sure to turn off any pop up blockers(e.g. uBlock Origin)
شي مذهل , ممكن تضيف combobox تختوي على اسماء الاعمدة ويمكن ان تعمل filter باكثر من حقل واكثر من قيمه سيكون ذلك مفيد جدا ...عموما شكرا لك كثيرا
Did ur couse cover how to build the new Modern VBA Listbox from scratch
No. That would be a full course itself as it's quite a large project.
You basically just reinvented the ListView with some extras.
You make it sound like a bad thing😀
Do you know if this will work in Access too? I maintain numerous Access applications and would love to use it
It should in theory, but I haven't tried it😀
@@Excelmacromastery i will try and get back to you
Paul, I've placed the add-in in the Excel add-in folder. But when I OK the add-in dialogue, I get an error "This filetype is not supported in Protected View", Can you please advise .... Thanks
You need to unblock the file. In File Explorer, right-click on the file and select properties. In the dialog check the "UnBlock" checkbox.
@@Excelmacromastery Thanks Paul, it's working. Great job !
I wish I can script like you. I will be the king
Thanks for your kind words.
the link is not available, can please check on it. thank you!!
The link is ok. Make sure you're not using pop up blockers
Very interesting but if data present in access database
What do you mean?
@@Excelmacromastery I have a feeling the question may be whether or not we can use an Access Database as a data source to populate the ListBox...
@@Excelmacromastery I mean if we use access database as a database and connection with excel then populate data in listbox.
Does the update record work for you? It did not seem to update a record.
That's just to demo retrieving data from the Listbox. I didn't add code to update.
Can you please add an example? I spent a lot of time to try to add that but it was too hard to figure out.
Awesome
Perfect, but the link to download is not working
Turn off any popup blockers or use private browser tab.
the problem is when scroll down the header also scrolling
Do you have python course?
Not at the moment
M A S T E R P I E C E. Nothing else to say.
Hope Randy see this.. he always use sheet instead of userform..
It annoys me to no end how many Excel features are stale. Something this good should be part of the app.
Thanks
I think this is too much, VBA should not be use for this. I mean, Excel worksheet already has this feature, you can enable filter etc. Unless you create a standalone new windows form application.
At least, he shares his knowledge
"VBA should not be use for this. I mean, Excel worksheet already has this feature" thats a bit contradictory!
the worksheet function listbox is linked somewhat to the sheet data Paul's modernlb is driven from an array!
"VBA should not be use for this" so why did Microsoft create 2 versions of this a listbox and listview in VBA?
Why is VBA still a thing? This should have been moved over to JavaScript years back by now. VBA is garbage.
@@geneanthony3421 can you do automation in excel with javascript?
@@geneanthony3421
If you could imagine how many factories, mostly smaller once, are still only using excel and access for managing stock and so on...! I think next 20 years it will still be applied for sure...!
And specifically for me it's a kind of retro-programming, just because I grew up with VBA, and I never want to miss this time to be honest.
So, out of my view you're sort of disrespectful with VBA and even with the people who are using, not matter why they're using it...!
Everything started somewhere...!
@@geneanthony3421
If you could imagine how many factories, mostly smaller once, are still only using excel and access for managing stock and so on...! I think next 20 years it will still be applied for sure...!
And specifically for me it's a kind of retro-programming, just because I grew up with VBA, and I never want to miss this time to be honest.
So, out of my view you're sort of disrespectful with VBA and even with the people who are using, not matter why they're using it...!
Everything started somewhere...!
So why are you watching this?
Why is VBA still a thing? He has done a video on that!
@@rods6405 I’m not watching, it came up in my feed and I browsed it quickly. I’m saying that it’s odd that VBA is still around, it should be a distant memory by this point
Wonderful! Hats off Paul! you made it so easy and simple for us. Very curious to know what skill and knowledge are required to develop such sophisticated addons. You must have used some components/controls that aren't intrinsic in Excel VBA, isn't it?
Thanks. I might do a video, on how I built it, if there is sufficient interest.
@@Excelmacromastery There sure is!
@@Excelmacromastery I am sure, there are plenty!