Automatically entered time and date

Hi,

I need my excel file to automatically enter date and time at 2 specific cell (separately).
Eg : Date at cell "AF5" & time at cell "AF6"

Currently I'm using following code for manually entering time :
ActiveCell.Value = Time()

Thanks in advance :-)

Hi,
where is Your bit of code located?

It could be done automatically when the code is located on 'worksheet open' event like:

Please Login or Register  to view this content.

or anything You want.

M

Hi Miroslav R.
I'm still new to this VBA stuff...

What is the meaning bit of code?
Actually the code i'm using is assigned to a command button...

TQ for your reply, i'll try it

OK, question again..
How to enter the code?

Dear Miroslav,

Sorry, I can' t get the VBA to work, I've change the worksheet name to sheets(1) and
also nothing happen ... what when wrong ?

Wbk_Open_Event.xlsm

Hi,

go to VBA editor (ALT+F11) and in explorer window doubleclick 'ThisWorkbook'. There You will find what were I talking about...

Regards

M

tq Miroslav,
ur example very clear to me
Thank you for your help


Sent from my iPhone using Tapatalk