Run a macro when the date is changed..

Closed
SARC - Aug 22, 2010 at 10:25 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Aug 24, 2010 at 08:49 AM
Hello,

I have a simple code to continue a serial number every time i reopen a workbook,.. heres the code..

Private Sub Workbook_Open() 

Sheets("Sheet1").Range("A5") = Sheets("Sheet1").Range("A5") + 1 
End Sub


(this code was done for me by "Rizvisa)

I would like to know if its possible for this formula to work only if i change the date on cell E7.

Thanks....

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 24, 2010 at 08:49 AM
You have to use Change event of that sheet. Just as this was open event of the workbook
1