Home |
Search |
Today's Posts |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey Gord! Many thanks!
Now It works.. and like Jon Peltier said, it´s better a conditional formatting than a msgBox... Now it´s done! Regards from Brasil! Claudio Marques Jon Peltier wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do update inventory | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions |