Cell formual result change - Message

  • Thread starter Thread starter al007
  • Start date Start date
A

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???
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Message Box should Popup on condition 3
Altered pasting functionality 3
Goto Reference:="abc" where abc is formula result 5
Is it Possible 1
Trouble with conflicting IsBlank() and CountBlank() results 4
Subtract cell formula from existing cell formula 2
Run-Time error '13': Type mismatch 1

Back
Top