Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to get a MsgBox to pop up if the value entered into a cell is
equal to or greater than the value in another cell, but no MsgBox ever comes up. The code is in the sheet I'm working on. Help! Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Target.Address = "$H$3" Then If Target.Value = "$B$3" Then MsgBox "That Entry is NOT ALLOWED!" End If End If ws_exit: Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 data validation not working | Excel Discussion (Misc queries) | |||
Validation From List Not Working | Excel Discussion (Misc queries) | |||
Validation problem with list 2 working | Excel Discussion (Misc queries) | |||
Data Validation not working!! Please help!!!! | Excel Discussion (Misc queries) | |||
Data Validation Not Working | Excel Discussion (Misc queries) |