Previous Topic Next Topic

Run a macro when the date is changed..

Closed
SARC - Aug 22, 2010 at 10:25 PM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Anyone's dm order all weird ?
Tillyleon111 -
toogleeful -

2 responses
someone hacked my fb account and changed my password
mik -
aceventura12345 -

13 responses
How to unlock fb account with date of birth i need link
Sy -
HelpiOS -

1 response
Facebook hacked and contact information changed
ChelseaFullwood -
cornwallav8r -

40 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response