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 767
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