tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,900
- Office Version
- 365
- 2019
- Platform
- Windows
I have the following code:
If I select cell A1 and pressed delete, it correctly shows the message:
However, when I selected multiple cells, for example, A1 to A3, then pressed delete, the message still only shows:
What can I do to make the message box show:
or perhaps make the message box appear three times:
and
and
Thanks
Code:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Row " & Target.Row & " has been changed."
End Sub
If I select cell A1 and pressed delete, it correctly shows the message:
Code:
Row 1 has been changed
However, when I selected multiple cells, for example, A1 to A3, then pressed delete, the message still only shows:
Code:
Row 1 has been changed
What can I do to make the message box show:
Code:
Row 1:3 has been changed
or perhaps make the message box appear three times:
Code:
Row 1 has been changed
and
Code:
Row 2 has been changed
and
Code:
Row 3 has been changed
Thanks