!Congratulations! It is an incredible complement and is very well developed friend and is extremely useful, I cannot imagine how much effort and time you have dedicated to the development of this tool and I really want to apply the ADD-in in all my projects that use data. However; I wonder !! If you got here and you achieved such development, you don't think it would be tempting to dedicate a little more about your time, to achieve a real azaña with the listbox? I refer specifically to 4 fundamental aspects and are the following: - Color configuration in the columns titles, both of the backcolor and the Fontbold from the initialize of the Userform, - Multiline configuration of the column titles label, to make it more versatile with more descriptive and more legible names - Column data (Left, Center, Right) optional from the initialize of the Userform - Editable data in the same Listbox line, without the need to call another form to make the changes. These 4 missing aspects in your ADD-in, would make the listbox a real work tool for all VBA developers. And all thanks to you, to your knowledge and tenacity to manage to transform this active control "listbox" so interesting in their properties and overcome the "ListView" in their abilities. I hope you consider it in your development and from here to time you are surprised with your ADD-in, version 2.0.
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.
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.
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.
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.
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!
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?
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!!!
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
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.
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.
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.
Hello seem I can't access to your mentioned link
!Congratulations!
It is an incredible complement and is very well developed friend and is extremely useful, I cannot imagine how much effort and time you have dedicated to the development of this tool and I really want to apply the ADD-in in all my projects that use data.
However; I wonder !!
If you got here and you achieved such development, you don't think it would be tempting to dedicate a little more about your time, to achieve a real azaña with the listbox?
I refer specifically to 4 fundamental aspects and are the following:
- Color configuration in the columns titles, both of the backcolor and the Fontbold from the initialize of the Userform,
- Multiline configuration of the column titles label, to make it more versatile with more descriptive and more legible names
- Column data (Left, Center, Right) optional from the initialize of the Userform
- Editable data in the same Listbox line, without the need to call another form to make the changes.
These 4 missing aspects in your ADD-in, would make the listbox a real work tool for all VBA developers.
And all thanks to you, to your knowledge and tenacity to manage to transform this active control "listbox" so interesting in their properties and overcome the "ListView" in their abilities.
I hope you consider it in your development and from here to time you are surprised with your ADD-in, version 2.0.
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.
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 👏🏼
Amazing add-in thank you for sharing with source code!
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.
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!
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
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/
I salute you Paul for creating a masterpiece, you’ve made our lives simpler. Thank you! 😊
My pleasure!
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!
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!
This Great man, Tnx a million. I subscribed to your channel just now to learn more from you.
Great job Paul!
Intrigued to take a look at the inner workings of this.
Thanks Ben
Boom!!!🎉 Amazing work and so much efforts spent! Thanks Paul!👍👍👍
My pleasure!!
You nailed it. Awesome work. Thank you!
Much appreciated!
The coolest Listbox so far!!!
Thanks
There are some neat features in there, like the pagination,, but honestly, much of this is already covered in the ListView control.
And that is why you are a legend!
Thanks😀
Pretty cool tool! Thank you for sharing!
You're welcome.
Impressive!!
It's awesome and amazing, great job.
Thank you! Cheers!
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?
Thank you verry match, it is Brilliant.
I'm glad you like it
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
How much time did you spend on this? Just curious.
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.
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…
You rock.
one word, "Amazing"
Thanks
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
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?
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
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.
I wish I can script like you. I will be the king
Thanks for your kind words.
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.
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 !
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.
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.
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)
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
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
شي مذهل , ممكن تضيف combobox تختوي على اسماء الاعمدة ويمكن ان تعمل filter باكثر من حقل واكثر من قيمه سيكون ذلك مفيد جدا ...عموما شكرا لك كثيرا
Awesome
Perfect, but the link to download is not working
Turn off any popup blockers or use private browser tab.
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.
Do you have python course?
Not at the moment
You basically just reinvented the ListView with some extras.
You make it sound like a bad thing😀
M A S T E R P I E C E. Nothing else to say.
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.
the problem is when scroll down the header also scrolling
It annoys me to no end how many Excel features are stale. Something this good should be part of the app.
Thanks
Hope Randy see this.. he always use sheet instead of userform..
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!