Add Current date and time when pressing a command button
 

Hello,

I would like to get the current date and time when pressing a comman button
in cell A5 what would the vba code be? Any help will be appreicated.
Thank you in advance.

Regards,

Add Current date and time when pressing a command button
 

Hello;

Cells(5, 1) = Format(Now, "DD/MM/YYYY : HH/MM/SS")

The format can be adjusted according to your regional settings.


--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (the country were they live some 18 feet beyond sea level)
--
E:
W: www.spreadsheetsolutions.nl
--
"CAM" wrote in message
...

Hello,

I would like to get the current date and time when pressing a comman
button in cell A5 what would the vba code be? Any help will be
appreicated. Thank you in advance.

Regards,

Add Current date and time when pressing a command button
 

Mark,

Thanks for the tip. I appreciate your help.

Regards


"Spreadsheet Solutions" wrote in message
...
Hello;

Cells(5, 1) = Format(Now, "DD/MM/YYYY : HH/MM/SS")

The format can be adjusted according to your regional settings.


--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (the country were they live some 18 feet beyond sea level)
--
E:
W: www.spreadsheetsolutions.nl
--
"CAM" wrote in message
...

Hello,

I would like to get the current date and time when pressing a comman
button in cell A5 what would the vba code be? Any help will be
appreicated. Thank you in advance.

Regards,