Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
I want a message box to popup if a cell(which already contains a function) is
over a certain value. Data validation won't work because the user isn't entering data into the cell. What would be the best way to do this? Basically- If A1134.16 then MsgBox "You are over your limit" Thanks for the help!! -- Thanks, Nikki |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
How about highlighting it in colour, that is Conditional Formatting?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nikki" wrote in message ... I want a message box to popup if a cell(which already contains a function) is over a certain value. Data validation won't work because the user isn't entering data into the cell. What would be the best way to do this? Basically- If A1134.16 then MsgBox "You are over your limit" Thanks for the help!! -- Thanks, Nikki |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
I already have it doing that-This is a really slow user.
-- Thanks, Nikki "Bob Phillips" wrote: How about highlighting it in colour, that is Conditional Formatting? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nikki" wrote in message ... I want a message box to popup if a cell(which already contains a function) is over a certain value. Data validation won't work because the user isn't entering data into the cell. What would be the best way to do this? Basically- If A1134.16 then MsgBox "You are over your limit" Thanks for the help!! -- Thanks, Nikki |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
In cell B1, type "You are over your limit", then change the font color to
white (so it can't be seen). In the same cell, use conditional formatting ("Format", "Conditional Formatting") to change the font color to black when A1 is 134.16. "Nikki" wrote: I want a message box to popup if a cell(which already contains a function) is over a certain value. Data validation won't work because the user isn't entering data into the cell. What would be the best way to do this? Basically- If A1134.16 then MsgBox "You are over your limit" Thanks for the help!! -- Thanks, Nikki |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
I have thought of that as well- actually I did an if statement, but I thought
a box would be better. I am assuming from the responses this is either not a good idea or can't be done. -- Thanks, Nikki "JR" wrote: In cell B1, type "You are over your limit", then change the font color to white (so it can't be seen). In the same cell, use conditional formatting ("Format", "Conditional Formatting") to change the font color to black when A1 is 134.16. "Nikki" wrote: I want a message box to popup if a cell(which already contains a function) is over a certain value. Data validation won't work because the user isn't entering data into the cell. What would be the best way to do this? Basically- If A1134.16 then MsgBox "You are over your limit" Thanks for the help!! -- Thanks, Nikki |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
You c an do it with event code, but the message will pop-up every time it is
still wrong and the sheet recalculates. And if as you ay the user is slow, what will force them to correct it? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nikki" wrote in message ... I have thought of that as well- actually I did an if statement, but I thought a box would be better. I am assuming from the responses this is either not a good idea or can't be done. -- Thanks, Nikki "JR" wrote: In cell B1, type "You are over your limit", then change the font color to white (so it can't be seen). In the same cell, use conditional formatting ("Format", "Conditional Formatting") to change the font color to black when A1 is 134.16. "Nikki" wrote: I want a message box to popup if a cell(which already contains a function) is over a certain value. Data validation won't work because the user isn't entering data into the cell. What would be the best way to do this? Basically- If A1134.16 then MsgBox "You are over your limit" Thanks for the help!! -- Thanks, Nikki |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
Couldn't you create some code that toggled a comment box when the sheet
recaclulates? That way when the sheet recalculates it won't show a msg box, only show the comment. And if the comment is already showing it won't do anything. I don't know how to do it, but I assume it would be easy for someone familiar with the language. If I were making the file, I would make the formula output an error msg instead of the result. For instance... =IF(A1+B112,"Result is too high, please adjust values.",A1+B1) "Bob Phillips" wrote: You c an do it with event code, but the message will pop-up every time it is still wrong and the sheet recalculates. And if as you ay the user is slow, what will force them to correct it? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nikki" wrote in message ... I have thought of that as well- actually I did an if statement, but I thought a box would be better. I am assuming from the responses this is either not a good idea or can't be done. -- Thanks, Nikki "JR" wrote: In cell B1, type "You are over your limit", then change the font color to white (so it can't be seen). In the same cell, use conditional formatting ("Format", "Conditional Formatting") to change the font color to black when A1 is 134.16. "Nikki" wrote: I want a message box to popup if a cell(which already contains a function) is over a certain value. Data validation won't work because the user isn't entering data into the cell. What would be the best way to do this? Basically- If A1134.16 then MsgBox "You are over your limit" Thanks for the help!! -- Thanks, Nikki |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
"Sloth" wrote in message ... Couldn't you create some code that toggled a comment box when the sheet recaclulates? That way when the sheet recalculates it won't show a msg box, only show the comment. And if the comment is already showing it won't do anything. I don't know how to do it, but I assume it would be easy for someone familiar with the language. Same problem. If the users are a boit slow, why would they look at the comments? If I were making the file, I would make the formula output an error msg instead of the result. For instance... =IF(A1+B112,"Result is too high, please adjust values.",A1+B1) I would use conditional formatting. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then Message Box
I went ahead with the conditional formatting and an If statement. I merged a
bunch of cells together and made a big red box that said my message. Your point about them closing the message box and forgetting it or maybe not reading it was good. This way the big message won't go away until the error is fixed. Thanks for the help- like I said I didn't think about a msgbox being less annoying. -- Thanks, Nikki "Bob Phillips" wrote: "Sloth" wrote in message ... Couldn't you create some code that toggled a comment box when the sheet recaclulates? That way when the sheet recalculates it won't show a msg box, only show the comment. And if the comment is already showing it won't do anything. I don't know how to do it, but I assume it would be easy for someone familiar with the language. Same problem. If the users are a boit slow, why would they look at the comments? If I were making the file, I would make the formula output an error msg instead of the result. For instance... =IF(A1+B112,"Result is too high, please adjust values.",A1+B1) I would use conditional formatting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I control where the input message appears? | Excel Discussion (Misc queries) | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions |