Hi good people,
I have searched and finally found pieces of code that I put together to accomplish the following: I have two drop downs B2 and D2. B2 drop down selects different text while D2 selects different values. What I really need to happen is when I make a change in B2, the value in D2 must change to 102. Then after this I must be free still to select any figure using D2. It's required to change to 102 only when I use B2. I have a code but it keeps executing and forcing D2 to 102. I'm sure it's just something small, any and all help will be accepted with great appreciation. This is the code I have:
thank you ...If Not Range("B2") Is Nothing Then Range("D2").Value = 102
Reply With Quote