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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
You must log in or register to reply here.

Similar threads

M
  • Solved
Macro stops after message box appear
Replies
3
Views
424
bobsan42
bobsan42
R
  • Solved
Message box to stop Macro if two cells are filled
Replies
5
Views
226
Joe4
Joe4
D
  • Solved
VBA Excel OpenDialogBox then Transfer the information to cell
Replies
5
Views
524
Daniza Morla
D
G
  • Solved
Return to original text box in case of an error
Replies
5
Views
359
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
457
rlv01
R

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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