macro to validate cells are filled before going to next row.

Hi all,
I want to know how can i write a macro which validates the current row before moving to another.

for example if the user is in the row number 3 and he clicks on row 10. i want to run a macro which validates if certain fields are filled in row number 3 before he goes to row 10.

How can i do it?

hey ballack....

yea this is posible, how many or whats fields do you want to check and what you want to check them for??

Stuie, I want to check for around 4 columns in that row .
I want to check for eg. if say Col A has certain value then the col B should have a specific value.

thank you.

Can anyone help me with this?

ok,
I have a Column called Country and a column called State .
And the validations i have to do is

1).if the country is USA then State must be specified.

If the State is not specified i must send a pop up message when user tries to moves to next cell and the user must not be allowed to move to next cell.