I've basically been cleaning up a system that someone else built this past week (on top of 4-5 months of missing information, clerical errors, typos, etc). I can not find any answers for this issue (maybe I'm just asking the wrong questions..)
So there are 3 cascading drop downs from a separate worksheet database just split into 3 columns with a main category, sub, then the last option (not sure how many ways there are to build the cascading lists).
What is happening is the lists seem to be getting hung up. (so no matter what I choose on any row/column that have the lists) The last 2 lists stay the same.I've tried deleting all info in the whole row, clearing the form (the macro clears it) and the only way I can figure to solve the problem is clear the form, exit excel and restart excel (saving even after it gets stuck is no issue).
It seems to be something to do with picking the first 2 categories and not choosing the 3rd option, but every time I think I have a specific way of making it happen repeatedly, there are situations where it works.
Also there are 3 different forms that use the same lists, and it will get stuck on all 3 worksheets.

Any ideas, thoughts, help or even just pointing me in the right direction to search for a solution would be greatly appreciated.