How to lock the 1st drop down list

Hello All,

Long time viewer but this is my first post. I have two drop down list that are interactive with each other on my form. The 2nd list is dependent on what is selected in the 1st list (indirect). So far they work great. The only issue I have is, excel will allow the user to change their selection in the 1st drop down list without making them change their selection in the 2nd drop down list. I need excel to zero or clear the 2nd list if a change is made to the 1st list. It looks like excel is recognizing this as a error too. When I make a change in the 1st list without changing the 2nd list and I click on "circle invalid data" it circles the 2nd list. Is there a way to lock this down via a formula or macro? Thanks in advance for your help and just let me know if you need anything else from me.


P.S. Does anyone know how to keep the little drop down arrow showing all the time? Even if you are not clicked on that cell?

Do you mean like this???

Pretty simple These are control combo boxes. See more example and explanation. Hope this link would help you. Gotta say that they work like Data Validation Lists...

So if I could help you, pls mark this thread as solved

1. To mark your thread solved do the following:
2. Go to the first post
3. Click edit
4. Click Advance
5. Just below the word "Title:" you will see a dropdown with the word No prefix.
6. Change to Solve
7. Click Save