I have 3 drop down options. I want the MsgBox to show when a particular selection is chose from dropdown 2 only. The VBA I created allows this to happen. However, when an option is chosen from dropdown 3, the same MsgBox appears. I only want the MsgBox to show on one occasion following the particular selection from dropdown 2.
I have attached a sample spread sheet to show my code and to display what is happening.
Hope that makes sense and if anyone can offer any assistance it would be greatly appreciated
Bookmarks