Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box
I want a message box to display if any of the values in column J are
negative. This is what I put, however, I get a run time error. Dim LR As Long LR = LastRow(Sheets("Outage")) Dim ErrorMSG As String If Worksheets("Outage").Range("J10: LR").Value = negative Then ErrorMSG = MsgBox("Warning. There are negative MW values. Please recalculate using smaller MW values.") End If Any suggestions? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace Excel Message w/Custom Message | Excel Programming | |||
Intercept/replace standard 'cell protected' message with my own message? | Excel Programming | |||
Opening an attachment of a message that has a message as attachmen | Excel Programming | |||
changing the message in an error message | Excel Worksheet Functions | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |