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,

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: (E-Mail Removed)
W: www.spreadsheetsolutions.nl
--
"CAM" <(E-Mail Removed)> wrote in message
news:7360B128-1D1E-4EBB-9900-(E-Mail Removed)...
>
> 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,
>
>

Mark,

Thanks for the tip. I appreciate your help.

Regards


"Spreadsheet Solutions" <(E-Mail Removed)> wrote in message
news:493e1259$0$8947$(E-Mail Removed)...
> 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: (E-Mail Removed)
> W: www.spreadsheetsolutions.nl
> --
> "CAM" <(E-Mail Removed)> wrote in message
> news:7360B128-1D1E-4EBB-9900-(E-Mail Removed)...
>>
>> 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,
>>
>>
>