Cell formual result change - Message

[al007]

I'm looking for an event macro which would inform a user that the cell
fromula result of A1>1 and if he wants to continue or not (ie telling
him that there is a double count)
Anybody can help???

[Tom Ogilvy]

Possibly the calculate event although you would have to temper it with a
static variable to only prompt with a change in the value in A1.

--
Regards,
Tom Ogilvy


"al007" <transferxxx@gmail.com> wrote in message
news:1132055791.754792.221530@g47g2000cwa.googlegroups.com...
> I'm looking for an event macro which would inform a user that the cell
> fromula result of A1>1 and if he wants to continue or not (ie telling
> him that there is a double count)
> Anybody can help???
>