Onclick the button view the time in activecell

Closed
vaali - May 1, 2017 at 08:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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"
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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