Hi guys, easy one for you. Just need for there to be a pop up box with the message "Warning" whenever I select cell A1 where cell A2 ="X". e.g. if cell A2 does equals anything but "X" then there will be no warning message
Thanks in advance
Hi guys, easy one for you. Just need for there to be a pop up box with the message "Warning" whenever I select cell A1 where cell A2 ="X". e.g. if cell A2 does equals anything but "X" then there will be no warning message
Thanks in advance
I think you are looking for something like this, placed in SHEET1 or whatever sheet you need:
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1:A2")) Is Nothing Then If Range("A2") = "X" And Range("A1") <> "" Then MsgBox "Change Made!" Else Exit Sub End If End If End Sub
you need the SelectionChange event and not the Change event
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks