EXCEL VBA - Implementing timestamps

Copper Contributor

Hi everyone,


After clicking on a Shape, I would like to save the current time and the current "Total Points". (Row 32). My goal is to see the changes of the Total Points over a time period.


For example, 

The shape was clicked today at 3 p.m. - The current score is 0 points [The time and points shall be displayed in E32 & F32]

The shape was clicked the day before yesterday at 2 p.m. - The score was 5 points [The time and points shall be displayed in E33 & F33]


Your support is highly appreciated. Thank you very much and best regards, J



2 Replies
best response confirmed by Juanito420 (Copper Contributor)


See the attached demo workbook.

@Hans Vogelaar
Thank you very much for your support and reply!