Worksheet change VBA to set cell value, same row, different column ?

NikonMan

New member
Joined
Feb 7, 2013
Messages
4
Reaction score
0
Points
0
Greetings all -

I am new to VBA and am trying to construct the following:

Where:

Column "Q", cells Q5:Q55, contain a drop-down pick list of 4 items ("H1", "H2", "I2", & "J2").
And
Column "L", cells L5:L55, have no data and no data validation restrictions using the built in functions.

When:

If the cell in row "Q" is "I2"
The intersecting cell in row "L" is = to "NA"
Else
The cell in row "L" can be any integer value between "1" and "99"

Preferably this would occur whenever the value of "Q" is changed to "I2" regardless of anything else.

Example:

1. Q20= "I2", then L20 = "NA"
2. Q21= "H1" or "H2" or "J2", then L21 = "1" or "2" .... "99" but not "100" or above.

Can anyone assist?

Many thanks in advance.

-Steve
 
Top