ExcelBanter - VBA time and date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA time and date? (https://www.excelbanter.com/excel-programming/404342-vba-time-date.html)

Steve[_107_]

VBA time and date?

On selecting a commandbutton I need to automatically insert the time and
date into a cell. I know that NOW() would do that but how do i get the time
and date in VBA?

thx

Steve

---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080115-0, 15/01/2008
Tested on: 16/01/2008 09:27:14
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com

Mike H

VBA time and date?

Maybe this

Sub Button1_Click()
Range("A1").Value = Now
End Sub

Mike

"Steve" wrote:

On selecting a commandbutton I need to automatically insert the time and
date into a cell. I know that NOW() would do that but how do i get the time
and date in VBA?

thx

Steve

---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080115-0, 15/01/2008
Tested on: 16/01/2008 09:27:14
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com

All times are GMT +1. The time now is 07:10 PM.