msg box macro

[ssaifan]

i want to check 2 cells H10 and I10 .....using macro....
they have dates in those cells......

if H10>= I10 , then do nothing ...
if I10 > H10 ...then a msg box shud pop up and say that " Index InValid "

How do i do this ...

Pls help..

 

[texasalynn]

take a look at data validation. You also might want to do a search on this board for some excellent examples.

HTH . . . texasalynn

 

[ssaifan]

can that give me a pop up window ?

 

[texasalynn]

Yes and doesn't require a macro

texasalynn

 

[ssaifan]

how do i do that >?
i just tried....

it dint work
can u help

 

[texasalynn]

what did you try? On the setting you change it to custom and put in the formula you gave

=I10>H10

Then go to the error alert and type in what you want the message to be.

BTW: searching the forum really does offer great solutions and examples.

texasalynn

 

[ssaifan]

did not work

as my values are not inputs ....but are formauls....

data validation doesnot work on formula...

thats why i asked for a macro...

can u help