Prompt User, Error Message to Correct Invalid/Failed Returned Values

T

TheJoker

New Member
Joined
Jul 8, 2011
Messages
6
Hello, I would like to create a box that pops-up and prompts the user with an error message: "Return value is invalid. Please click 'OK' to correct." when a conditionally formatted cell returns an out of tolerance deviation (computed from a three-set data entry).

How can this be done? Thank you so much!
 
Sort by date Sort by votes
What is it that tells us that "all data is recorded"? When a particular cell changes? If so, which cell, and how is it changed: by someone entering a value into it from the keyboard or as the result of a recalculation?
 
Upvote 0

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
You must log in or register to reply here.

Similar threads

M
  • Solved
Macro stops after message box appear
Replies
3
Views
531
bobsan42
bobsan42
R
  • Solved
Message box to stop Macro if two cells are filled
Replies
5
Views
262
Joe4
Joe4
D
  • Solved
VBA Excel OpenDialogBox then Transfer the information to cell
Replies
5
Views
540
Daniza Morla
D
G
  • Solved
Return to original text box in case of an error
Replies
5
Views
365
Legacy 143009
L
J
  • Question Question
Vba code to display the 3 values contained in a specified column in a message box
Replies
1
Views
477
rlv01
R

Forum statistics

Threads
1,224,513
Messages
6,179,212
Members
452,895
Latest member
BILLING GUY

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top