View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] brett.kaplan@gmail.com is offline
external usenet poster
 
Posts: 48
Default 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