Onclick the button view the time in activecell

Closed
vaali - May 1, 2017 at 08:38 AM
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
- May 4, 2017 at 11:06 AM
Hi,

I am using this code it's run successfully but each time click the button then overall change the cells. I want each cell view the current time not change the previous time in before cell. please help
activecell = "=now()"
activecell.numberformate = "hh:mm"

1 reply

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
May 4, 2017 at 11:06 AM
Hi Vaali,

Can't say your question is very clear, but if you don't want the previous time to be replaced, then don't select that cell before running the code.

Best regards,
Trowa
0