Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box
I have a cell that checks the vertical totals with the horizontal totals and
shows the difference if they are difference. I would like to add a pop up message box if they are different using sheet code. Thanks, Gordy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box
Right click the sheet tab and select view code. Add the following. You will
need to change the cell reference... Private Sub Worksheet_Change(ByVal Target As Range) If Round(Range("A1"), 3) < 0 Then MsgBox "Out of Balance" End Sub -- HTH... Jim Thomlinson "Gordy99" wrote: I have a cell that checks the vertical totals with the horizontal totals and shows the difference if they are difference. I would like to add a pop up message box if they are different using sheet code. Thanks, Gordy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box
Surely, vertical totals will be a sum of the column, horizontal totals will
be a sum of the row, so they will be different? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gordy99" wrote in message ... I have a cell that checks the vertical totals with the horizontal totals and shows the difference if they are difference. I would like to add a pop up message box if they are different using sheet code. Thanks, Gordy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace VBA run-time error message with custom message | Excel Programming | |||
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 | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |