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"

Onclick the button view the time in activecell
Lenovo power button blinks 3 times ✓ - Forum - Laptop
Lenovo power button blinking 3 times ✓ - Forum - Hardware
Lenovo thinkpad won't turn on power button blinks 3 times ✓ - Forum - Hardware
Lenovo laptop power button flashing 3 times ✓ - Forum - Laptop
Lenovo thinkpad power button blinking 3 times - Forum - Laptop

1 reply

Answer 1 / 1

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

Subscribe To Our Newsletter!