Run a macro when the date is changed..

[SARC777]

Hello,

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

Please Login or Register  to view this content.

(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....

[quekbc]

Yes, it is possible. To do so, go into the VB Editor (Alt+F11), on the top left, look for Sheet1 object and double click it.

Insert the following code.

Please Login or Register  to view this content.

Also, I'd recommend using named ranges for these cells (A5 and E7) and using them in VBA to prevent future errors from adding in rows or columns.

[SARC777]

Ok thanks..

Heres how i combined the 2 codes.. it diidnt work for .... could you help m out pls..

Please Login or Register  to view this content.

Thanks...

[SARC777]

My apologies,,.. your code works quekbc... Thanks again.................

[quekbc]

Excellent... that's good to hear.