Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to monitor when any of the data in my group of
cells gets modified or deleted. Here is how my code looks: Private Sub Worksheet_Change (ByVal Target As Range) Select Case Target Case Range("A1") MsgBox ("A1 was just modified") Case Range "B1") MsgBox ("B1 was just modified") '..... etc. etc.. etc... Case Range ("M20") MsgBox ("M20 was just modified") Case Else ' Do nothing End Select End Sub Does anybody see anything wrong with this approach?? Is my code correct?? How can I code this in a more efficient manner?? Thank you all! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select Case syntax for multiple conditions ("and")? | Excel Programming | |||
Select Case "Procedure to large" Error | Excel Programming | |||
how do I count only lower case "x" and exclude upper case "X" | Excel Worksheet Functions | |||
Why Error Message "End Select without Select Case"? | Excel Programming | |||
Fix Code: Select Case and "Contains" selection | Excel Programming |