Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, can this be modified......
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Address = "$B$2" And UCase(Target.Value) = "Jim" Then MsgBox "Free time", vbExclamation, "" Range("C2").Activate End If End Sub To something like this......? Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Address = "sheet1!B2:B10" And UCase(Target.Value) = "sheet2!F2:F10" Then MsgBox "Free time", vbExclamation, "" Range("C2").Activate End If End Sub Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Popup box moving to new tab | New Users to Excel | |||
Excel POPUP | Excel Worksheet Functions | |||
Popup MsgBox | Excel Discussion (Misc queries) | |||
Add a warning popup to a Macro Button | Excel Worksheet Functions | |||
"Why did we get here????" popup | Excel Discussion (Misc queries) |