How to put Date Without Click on any button

[Umesh Chahar]

Hi all,
please help me out , i want to write a macro such that when i will open the sheet the current date will get entered on its own ,as the sheet get opened and time also the current system time will get entered on its own .
If i open the sheet for the first time then the date get entered to the first row and when i will open it for the second time then date will get entered to the second row and same for the time also.

 

[Somendra Misra]

Hi Umesh,

See this file, the current date & time will be entered in column A of sheet1 every time the file is opened.

Regards,

 

[Umesh Chahar]

Hi Somendra ,
thanks for answering my question , but i want date and time in seperate columns.

 

[Somendra Misra]

See this file.

Regards,

 

[akinkaraman]

Hello Somendra. I just want ask to learn how to use this.

I don't see any macros under macros. How can I use these?
I couldn't find and I am trying to learn.

Thanks..

 

[Marc L]

Hi,

in ThisWorkbook module :​

Private Sub Workbook_Open()
  Sheet1.Cells(Rows.Count, 1).End(xlUp)(2).Resize(, 2).Value = Array(Date, Time)
End Sub

Do you like it ? So thanks to click on bottom right Like !
​

 

[rumshar]

Hello Somendra. I just want ask to learn how to use this.

I don't see any macros under macros. How can I use these?
I couldn't find and I am trying to learn.

Thanks..

Hi,
You may find this useful!
http://www.cpearson.com/excel/Events.aspx

 

[akinkaraman]

I am checking. Thanks both..