POP UP BOX IN EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
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.

Format>Cells>CF>Formula 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Popping out Message Box! 4
Is there a way to create a pop-up window in Excel? 5
pop up box 1
Pop up Box 2
How to eliminate the autofill options box that pops up in excel? 1
MessageBox with tick box 3
Restrict cell entry until another cell has random text 3
A column will depend in B column 6

Back
Top