Onclick the button view the time in activecell

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
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

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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