Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
POP UP BOX IN EXCEL
I need to create a pop up box if say A1 NOT EQUAL TO B1!!!
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
POP UP BOX IN EXCEL
How are the values in A1 and B1 derived?
It might be easiest to place Conditional Formatting on A1 so's it turns color if not equal to B1. FormatCellsCFFormula is: =$A$1<$B$1 Format to a color and OK Alternate method for a real pop up box..................... This sheet event code will be triggered by a calculated change in A1 Private Sub Worksheet_Calculate() On Error GoTo stoppit Application.EnableEvents = False With Me.Range("A1") If .Value < Range("B1").Value Then MsgBox "Please be advised that A1 does not equal B1!!!" End If End With stoppit: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Wed, 1 Aug 2007 20:18:01 -0700, Peter wrote: I need to create a pop up box if say A1 NOT EQUAL TO B1!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|