Multi-Level Drop-Down with a Single Custom Function in Excel and VBA
HTML-код
- Опубликовано: 4 сен 2021
- 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.
thedatalabs.org/multi-level-d...
website - www.thedatalabs.org
email - info@thedatalabs.org
#MultiLevelDropDown #TheDataLabs
Thanks for watching! Please like, share, comment and subscribe.
Have a great day!
Wow! That's really a very intuitive video particularly that single UDF working for all levels
Thanks Satish!
Thank you for these videos. They are very helpful and informative. 👍
Excellent bro. Very informative D and useful to my business. Thanku keep it up.
Thank-You
Good video keep up bro
thank you very much for this tutorial!! can we use same macro code without UserForm and use excel cell instead?
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 ?
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
Thanks for your feedback!
good
ممنون
Brilliant 💕it
Thanks for your feedback!
How do I clear the selection and reselect again the combo boxes without going back to Home Page
very concise tutorial! thank you so much!
just thinking though, how can you implement this without using a UserForm? thanks!
Thanks for you feedback! This can be done. Please try to implement this without userform. Let us know if you face any issue.
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!
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
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
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.
hi ho do i subtract colums in vba code
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.
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!
I have the same problem. Are you able to get a solution?
Can we add this function in employee activity tracker 1.0
Yes, I think that is already there with different code. Thanks!
@@thedatalabs only drop-down code is there, I am planning to add department drop down and task drop-down. Like above.
I can't able to download , pls help
It is fixed now. Please check. Thanks!