apicsofcake
New Member
- Joined
- Sep 23, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Worksheet("Sheet1").Range("A:AE").NumberFormat = "dd/mmm/yy hh:mm AM/PM" Then
If timeStamp_Click = True Then
MsgBox "are you sure?"
End If
End Sub
//I want to fulfill two conditions,
First, when the cell within range A:AE, any of them is filled with timestamp
Then, when user clicks on timeStamp button, msg pops up
I don't know why the above codes don't work
Can somebody help with this?
If Worksheet("Sheet1").Range("A:AE").NumberFormat = "dd/mmm/yy hh:mm AM/PM" Then
If timeStamp_Click = True Then
MsgBox "are you sure?"
End If
End Sub
//I want to fulfill two conditions,
First, when the cell within range A:AE, any of them is filled with timestamp
Then, when user clicks on timeStamp button, msg pops up
I don't know why the above codes don't work
Can somebody help with this?