Run-time error '1004' while using multi-level drop down menus

[m3allim]

Hey there,

I have a table with some columns that are text fields (e.g. name) and then some columns that are single or multi-level drop down menus. The idea is that you enter a name first in one of the text fields, and then go to the drop downs and select your options. The drop downs work well, and I also wrote a VBA script to clear the content of the drop downs if you select another option from the menu (e.g. you change your first selection, then fields in drop down 2 and 3 will be set to blank).

If I, however, change or write something in the text fields, the script throws an exception ('1004') because the Target.Validation.Type = 3 has a value 'Expression not defined in context'. I added the script to this post. I created the drop downs using data validations.

Note: columns M, N, O, P, Q are the drop downs (referring to 13, 14 and 16 in the script)

Let me know if you need more details!

Thanks for your help!
G.

[AlphaFrog]

If you change a cell that is not a Data Validation cell, then you cannot check that cell's .Validation.Type.

Try this...

Please Login or Register  to view this content.

[m3allim]

Thanks so much AlphaFrog!! It works perfectly with your script above :-)