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!