| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box on cell content
Hi
I'm fairly new to this but grateful for any help. I need a warning or message box to pop up and stop invalid data being entered. If the user enters a value in a range (C31:U41) that causes a negative value in another range (C45:C55), then this is invalid data and they need to try again with correct data. Hopefully there's a simple answer to this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
message box on cell content
With C31 selected -
Data / Validation / Custom / Formula : =C45=0 Also see Input msg & Error alert tabs Copy (or drag) C31 down to C41 Regards, Peter T "Cooie" wrote in message ... Hi I'm fairly new to this but grateful for any help. I need a warning or message box to pop up and stop invalid data being entered. If the user enters a value in a range (C31:U41) that causes a negative value in another range (C45:C55), then this is invalid data and they need to try again with correct data. Hopefully there's a simple answer to this. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
message box on cell content
Thank you so much, it worked a treat.
Cooie "Peter T" wrote: With C31 selected - Data / Validation / Custom / Formula : =C45=0 Also see Input msg & Error alert tabs Copy (or drag) C31 down to C41 Regards, Peter T "Cooie" wrote in message ... Hi I'm fairly new to this but grateful for any help. I need a warning or message box to pop up and stop invalid data being entered. If the user enters a value in a range (C31:U41) that causes a negative value in another range (C45:C55), then this is invalid data and they need to try again with correct data. Hopefully there's a simple answer to this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening workbook - get error message : unreadable content, lostvbproject | Excel Programming | |||
| When content of a cell changes, content of another deletes | Excel Programming | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Intercept/replace standard 'cell protected' message with my own message? | Excel Programming | |||
| Incorporating cell content into a message in a formula | Excel Worksheet Functions | |||
Linear Mode
