I've been working on this very simplistic VB code. Please refer to the attached spread sheet. I need B15 to clear and display "select scenario" when A13 is changed. That works fine. I have the same routine for the next group of cells below but when I go to A17 and select the same code as A13 then B15 and B19 change, I don't want B15 to change anymore. This happens when I have the same value two or more times in the Colum named "code" please help, I'm an ag engineer and just starting to get familiar with VB.
Bookmarks