Thread: Dialog Boxes
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Dialog Boxes


Another way...
Use a custom number format in the cell with the formula.
The formula might look like... =A5-B5

The cell number format could look like...
[Red][<0]"Reimbursable data does not equal!";[Blue][=0]0;@
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"stacy05"
wrote in message
I don't know if this is possible in Excel, but here is what I want to do.
I want to create a "check" for the users. Basically 2 cells need to equal
eachother before they can sumbit the worksheet. What I would like to happen
is if the 2 cells don't equal a dialog block pops up saaying "Reimbursable
data does not equal!!".
Is this possible?

Thanks in advance!
Stacy