Dynamic drop-down at sheet with vba

NOTE: I reupload the test file because the other has one error at code for defining names to columna A and C at Data sheet (See code). Now it Works for the first column

Originally Posted by Judith_Chao

NOTE: I reupload the test file because the other has one error at code for defining names to columna A and C at Data sheet (See code). Now it Works for the first column

No one has any suggestion or idea I can try or formula code procedure I can search information of ?

Originally Posted by jaslake

Hi Judith_Chao

I've been trying to understand what you're attempting to do.

It APPEARS to me you're trying to Drill Down on the ListBox dependent on the selections in the Comboboxes but your existing Code and Named Ranges does not support that conclusion.

So, if you will, give us a step by step of what you're attempting to do.

Hi !

i explain myself. I try to make depending drop down at the sheet similar to this I have at the form.
The first five columns are intended to be filled by a drop down list at the sheet and searched by combobox at the userform.
At the userform I can make it dinamically and no problem. But at the shett I find that I must use names, that have limitations of names I can use. I want use name with apaces and no matter what symbols but I can't because I want to create depending dropdowns.
So for summary I have column 1 and 2 are depending values and column 3 and 4, 5 is independent. So if I put some value at colum1 I want show me some específico values at colum 2, and the same for 3-4. I obtain it and it makes dinamically at the userform but at the sheet I must use Indirect (and it don't permit dinamically ranges) and names don' permit spaces or symbols.

So I ask if there is another way, perhaps including code at the sheet to make it easier to update and mantein than using names and it's restrictions.

Any clarification you need please don hesitate to ask I'm really interested to know if that can be made without Indirect or name ranges.

No one have an idea or an indication to read or a way to search into ???

Any suggestion will be vey greatful