Timer Loop

How do create a macro to
run every 1 minute to check if cell A1 = "Y".

If A1 = "Y" run macro XXX and exit macro.
If A1 not equal Y, reset to run next 1 min.

I think Do Loop with

Exit Sub

any one?

Working with this....

How Do I change the repeat timing from 1min to 1sec or .1 sec or .05 sec.
VBA seems to mess up below 1 second....thanks for your help.


thanks