| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Error Message Once a Range is Activated
I have a spreadsheet that has a row that needs to equal 100. For example:
Cell C1 equals the sum of cells C2-C25 Cell C1 must equal "100" in order for the user to continue. Is there a VBA code that will only display a "Total Must Equal 100" message once row 1 has been activated? Or would it be better to create the code to be a 'hard stop' when the use tries to save? Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Error Message Once a Range is Activated
Please disregard ~ not as tough as I thought! :)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Activated Conditional Formats? | Excel Discussion (Misc queries) | |||
| conditional formatting error message | Excel Worksheet Functions | |||
| out of range error message | Excel Programming | |||
| message/dialog box auto open when excel file is activated | Excel Discussion (Misc queries) | |||
| Subscript Out Of Range Error Message | Excel Programming | |||
Linear Mode
