Continually check if condition is true in VBA

[brett.kaplan]

Hi,

I have a simple question, but can't figure it out. I want a macro to
one immediately if a certain cell is selected. The way I'm doing it is
checking ActiveCell.Row and ActiveCell.Column and if those match the
cell I want, the macro runs.

However, how do I set this to check every time a new cell is selected?

Thanks!

Brett

 

[Gary''s Student]

Yes:

Use an event macro:
the Worksheet selection change event macro

See
http://cpearson.com/excel/events.htm
for background into