View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default msgBox after update a cell

You still want a message box? You don't mind inconveniencing the users? Use
conditional formatting to highlight the cells that don't add up, and trust
the users to notice and fix them.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Claudio Silva" wrote in message
ps.com...
Yes... it realy dont!

Still waiting for a solution...

¬¬

Claudio Marques
Jon Peltier wrote:
I don't think DV works in this scenario.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Claudio Silva" wrote in message
ps.com...
Dear Andy,

In fact, i´m traying to use it..
But, without success..

I dont know exactly how to use this function with formulas
=(


Andy Morton wrote:
I look for solutions that avoid VB.
Have you tried Excel's built-in Data validation ?
Its's in the Data menu.
Not difficult to understand.
It checks data entered in a cell to see if it's conforms to your
criteria.
Not sure that it will work for what you need.

Andy