Forum Discussion

Juanito420's avatar
Juanito420
Copper Contributor
Jul 22, 2023

EXCEL VBA - Implementing timestamps

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

 

Resources