Error Message Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi...

On sheet "errorcheck" I have a cell (d4) that will show the value "error" if
other values do not add up properly. However, most of the data entry is
processed on another sheet called "data entry". What I'm after is some code
that will launch a message box in the data entry sheet if the word "error"
appears in cell d4 on the "errorcheck" sheet. Anyone got any code I could
find useful?
 
When would you like this mesage displayed. Before a person tries to save the
workbook? Before Close? Before Print? All of the above? None of the above???
 
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

How can I use this VB script to reset my values on other sheets? 1
Find the correct sheet then find a value on that sheet 8
Type mismatch error - 'run-time error 13' 14
VBA References 4
Reduce Numbers Down To A Specific Value 1
File Name changes with dates and Deleting Rows of Zeros 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Want to check if cell is blank before running macro 3

Back
Top