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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Excel OpenDialogBox then Transfer the information to cell
Replies
5
Views
268
Daniza Morla
D
G
  • Solved
Return to original text box in case of an error
Replies
5
Views
264
Legacy 143009
L
J
  • Question
Vba code to display the 3 values contained in a specified column in a message box
Replies
1
Views
305
rlv01
R
R
  • Solved
UserForm - If TextBox is blank, Error Message and return to form
Replies
4
Views
605
rachel06
R
A
  • Question
Run-time error '380' Could not set the Value property. Invalid property value
Replies
7
Views
321
aabrazil1
A

Forum statistics

Threads
1,215,949
Messages
6,127,888
Members
449,411
Latest member
AppellatePerson

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