Multi-Level Drop-Down with a Single Custom Function in Excel and VBA

How to create multi-level drop-down with a single custom function in Excel and VBA?

In this video, we will use how to use a Custom Defined Function in Excel and VBA. With a single function, we can create multi-level drop-down in few line of VBA code.

Please download the demo file from the below link.

#MultiLevelDropDown #TheDataLabs

Thanks for watching! Please like, share, comment and subscribe.

Have a great day!

[infosatish]

Wow! That's really a very intuitive video particularly that single UDF working for all levels

[autobotgeekse]

Thank you for these videos. They are very helpful and informative. 👍

[jayasri-ft]

Excellent bro. Very informative D and useful to my business. Thanku keep it up.

[harilibo]

This dependent multi-level drop down list is really useful for catalogue of products with different characteristics. It is also amazing that can be extended. I have not tried it yet but I am sure it can be. Really useful @TheDataLabs

[BalanRaluca]

thank you very much for this tutorial!! can we use same macro code without UserForm and use excel cell instead?

[djones]

very concise tutorial! thank you so much!

just thinking though, how can you implement this without using a UserForm? thanks!

[tomasburke]

Great video! I'm noticing that the ComboBoxes only populate if I use the form with the "Drop Down" tab open. If I use the form with another tab open, the ComboBoxes are left blank. Is there an easy workaround for this? Thanks!

[brucebanner]

I tried using the VBA code for the dynamic drop downs. But, I am having a “Compile error: Invalid use of property” On the DynamicList=“‘Drop Down’!” & amp: Range(.Cells(2, DropDownColumn), .Cells(iDeopDownLastRow, DropDownColumn)). Address The “.Address” becomes highlighted during compile with this error. Any help would be greatly appreciated (using Excel 2019), I enjoy the level of detail in your videos, very educational.

[Yorumcu]

Great tutorial thank you.Could you make Browse list of filter result? I mean This sample is find a record How can update like this kind sample
First :Chose Country
Second .Chose City (Chose's country)
Thirty: Chose zone (For example West, East, North etc)
and when chosen this than brows in this zone home adress list in bellow lines
How can make like this sample ?

[trinhlam]

Hello, i have a data base where 1 "sub category" exists in 2 different categories. How can i modify the code so that "Item" can be filtered based on the value "Category" AND "Subcategory "? Thanks for your help

[kunalgoswami]

Kindly help with code, if I intend not to use combox and "drop down" sheet seperately, i.e. I only want to use function standalone, and use it with any excel sheet

[corrinekam]

How do I clear the selection and reselect again the combo boxes without going back to Home Page

[kaitlync]

Not sure why but the filter is not working well from my end..it looks like the filter is just based on the previous column, not all previous columns...Can you please advise? Thanks in advance!

[sandeshhonde]

Would have been better to pass column header to combobox based on prev combo selection and list unique values of that column in next combo box. Its way too complex.

[yajiv]

Can we add this function in employee activity tracker 1.0

[wadhabadshahsaid]

hi ho do i subtract colums in vba code

[Kdevana]

I can't able to download, pls help