SOLVED

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

 

20230722_152919.jpg

2 Replies
best response confirmed by Juanito420 (Copper Contributor)
Solution

@Juanito420 

See the attached demo workbook.

@HansVogelaar
Thank you very much for your support and reply!
1 best response

Accepted Solutions
best response confirmed by Juanito420 (Copper Contributor)
Solution

@Juanito420 

See the attached demo workbook.

View solution in original post