Continually check if condition is true in VBA
 

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

Continually check if condition is true in VBA
 

Yes:

Use an event macro:
the Worksheet selection change event macro

See
http://cpearson.com/excel/events.htm
for background into
--
Gary's Student


" wrote:

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