Comparing Adjacent Columns in excel using vba macros

[rudhreswar kiran]

Hi ,

i would like to have a vba code for comparing two adjacent columns and alert if it meets the codition

a validate button is provided on excel on clicking it if column "A" is S then column "B" should not be empty and it shoould alert .
Note : If column A is not S then Column B value can be empty.Here it should alert on 2nd row not on 4th row.

thanx in advance

for ex:

col A col B
S 01/01/2001
S
S 02/02/2002
B
B 01/01/2005

[Andrew-R]

Something like this, perhaps...

Please Login or Register  to view this content.

[arlu1201]

Will there be only 1 such occurrence where there is S in col A and a blank in column B? Do you want 1 alert for every such cell? Or do you want a combined messagebox with all such occurrences?