I Built a Modern Listbox UI for Excel VBA

[@Excelmacromastery]

Let me know what you think about the Modern Listbox in the comments below 👇

[@MrGoudfay]

the link is not working ! i can't open the mwebpage to get the file

[@benjammin4067]

On first view i am absolutely amazed and cant wait to try it out.

[@yemcity7867]

Hello seem I can't access to your mentioned link

[@juanreynolds6831]

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

[@sebastian1200]

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.

[@sinus2220]

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.

[@Excelmacromastery]

Thanks for the suggestion.

[@deonvanniekerk7700]

Brilliant work! Respect 👏🏼

[@iincitr]

Amazing add-in thank you for sharing with source code!

[@gnambifrancois8771]

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.

[@activeresidence]

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.

[@Excelmacromastery]

You're very welcome Piotr!

[@LaurentGrandchamp]

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.

[@Excelmacromastery]

Go for it!

[@GabrielGarcia-pz3oj]

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!

[@Excelmacromastery]

You're welcome Gabriel

[@m-squaredcontractors9720]

I salute you Paul for creating a masterpiece, you’ve made our lives simpler. Thank you! 😊

[@Excelmacromastery]

My pleasure!

[@apbosh1]

Most generous of you! great piece of work. clever!

[@CloverGreenTea]

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.

[@Excelmacromastery]

The Excel VBA Handbook course is text based. Check it out here: theexcelvbahandbook.com/

[@benlinford_work]

Great job Paul! Intrigued to take a look at the inner workings of this.

[@Excelmacromastery]

Thanks Ben

[@mathassu4701]

And that is why you are a legend!

[@Excelmacromastery]

Thanks😀

[@قناة_أهل_مصر]

This Great man, Tnx a million. I subscribed to your channel just now to learn more from you.

[@maco21488]

The coolest Listbox so far!!!

[@Excelmacromastery]

Thanks

[@gonzaortin739]

You nailed it. Awesome work. Thank you!

[@Excelmacromastery]

Much appreciated!

[@kcell2042]

Impressive!!

[@AvocadoDiaboli]

There are some neat features in there, like the pagination,, but honestly, much of this is already covered in the ListView control.

[@johnwayne8059]

Boom!!!🎉 Amazing work and so much efforts spent! Thanks Paul!👍👍👍

[@Excelmacromastery]

My pleasure!!

[@tuzaguilar4201]

Pretty cool tool! Thank you for sharing!

[@Excelmacromastery]

You're welcome.

[@aljohnorillosa]

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!

[@robertoexceldasloterias]

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

[@hassanrozh6579]

It's awesome and amazing, great job.

[@Excelmacromastery]

Thank you! Cheers!

[@agusp1951]

one word, "Amazing"

[@Excelmacromastery]

Thanks

[@AdamskontongM]

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?

[@dieterlau2816]

Thank you verry match, it is Brilliant.

[@Excelmacromastery]

I'm glad you like it

[@nic18lee21]

You rock.

[@thesexiestguy]

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…

[@erendiz79]

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.

[@Excelmacromastery]

Let me know if you find any bugs. I will update the code accordingly.

[@erendiz79]

@@Excelmacromastery I am now still busy testing it, and i will mail you my findings.

[@aljohnorillosa]

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

[@rayearth9760]

How much time did you spend on this? Just curious.

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.

[@Excelmacromastery]

Glad you like it

[@rods6405]

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!

[@Excelmacromastery]

Glad you found it useful.

[@jonnathanjon1]

I wish I can script like you. I will be the king

[@Excelmacromastery]

Thanks for your kind words.

[@JonathanExcels]

Awesome

[@Dansel_B]

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 ?

[@Excelmacromastery]

The filter doesn't have that functionality at this time. Creating a filter similar to Excel is a major project by itself.

[@carlosdaroza]

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?

[@Excelmacromastery]

I don't use a Mac but to my knowledge UserForms are not available in recent Mac versions of Excel?

[@b99eu]

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

[@tommy704581]

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.

[@Excelmacromastery]

What @tommy704581 said.

[@b99eu]

@@tommy704581 Thanks for this hint. This will solve my issue.

[@alikhalil7683]

شي مذهل , ممكن تضيف combobox تختوي على اسماء الاعمدة ويمكن ان تعمل filter باكثر من حقل واكثر من قيمه سيكون ذلك مفيد جدا ...عموما شكرا لك كثيرا

[@activeresidence]

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

[@activeresidence]

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!!!

[@Excelmacromastery]

I have fixed that issue and one or two others in the latest version.

[@byteseq]

You basically just reinvented the ListView with some extras.

[@Excelmacromastery]

You make it sound like a bad thing😀

[@tanzhenger6229]

Did ur couse cover how to build the new Modern VBA Listbox from scratch

[@Excelmacromastery]

No. That would be a full course itself as it's quite a large project.

[@noambrand]

Does the update record work for you? It did not seem to update a record.

[@Excelmacromastery]

That's just to demo retrieving data from the Listbox. I didn't add code to update.

[@noambrand]

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.

[@Djblois1]

Do you know if this will work in Access too? I maintain numerous Access applications and would love to use it

[@Excelmacromastery]

It should in theory, but I haven't tried it😀

[@Djblois1]

@@Excelmacromastery i will try and get back to you

[@abcd2-k4s]

Very interesting but if data present in access database

[@Excelmacromastery]

What do you mean?

[@benlinford_work]

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

[@abcd2-k4s]

@@Excelmacromastery I mean if we use access database as a database and connection with excel then populate data in listbox.

[@SlapHead-r4k]

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

[@Excelmacromastery]

You need to unblock the file. In File Explorer, right-click on the file and select properties. In the dialog check the "UnBlock" checkbox.

[@SlapHead-r4k]

@@Excelmacromastery Thanks Paul, it's working. Great job !

[@federicorusalen874]

M A S T E R P I E C E. Nothing else to say.

[@SoulMateKsa]

Do you have python course?

[@Excelmacromastery]

Not at the moment

[@franciscosevilla4902]

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.

[@Excelmacromastery]

Make sure to turn off any pop up blockers(e.g. uBlock Origin)

[@johnclicelflores2385]

the link is not available, can please check on it. thank you!!

[@Excelmacromastery]

The link is ok. Make sure you're not using pop up blockers

[@ersingungor6101]

Perfect, but the link to download is not working

[@Excelmacromastery]

Turn off any popup blockers or use private browser tab.

[@BeepyDevelopment2]

the problem is when scroll down the header also scrolling

[@jbinmd]

It annoys me to no end how many Excel features are stale. Something this good should be part of the app.

[@Excelmacromastery]

Thanks

[@aljohnorillosa]

Hope Randy see this.. he always use sheet instead of userform..

[@greisboy425]

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.

[@dominiquejacob6406]

At least, he shares his knowledge

[@rods6405]

"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]

Why is VBA still a thing? This should have been moved over to JavaScript years back by now. VBA is garbage.

[@jonnathanjon1]

@@geneanthony3421 can you do automation in excel with javascript?

[@johnwayne8059]

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

[@johnwayne8059]

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

So why are you watching this? Why is VBA still a thing? He has done a video on that!

[@geneanthony3421]

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

[@Chandan7404]

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?

[@Excelmacromastery]

Thanks. I might do a video, on how I built it, if there is sufficient interest.

[@schymi841]

@@Excelmacromastery There sure is!

[@Chandan7404]

@@Excelmacromastery I am sure, there are plenty!