Elysium4Eternity
New Member
- Joined
- May 7, 2018
- Messages
- 12
Hello, there is a code where I'm being struggling with. I have this:
Withen an rivate Sub Worksheet_SelectionChange(ByVal Target As Range)
But I only need it to run once when I open the file on 01/01/2019 and not every time I click on my worksheet.
Code:
Range("A70").Value = Date
If Range("A70").Value = "01/01/2019" Then
Range("A71").Value = Range("A71").Value * 1.02
End If
Withen an rivate Sub Worksheet_SelectionChange(ByVal Target As Range)
But I only need it to run once when I open the file on 01/01/2019 and not every time I click on my worksheet.