Write down a code in VBA for excel to display current date and Time?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Write down a code in VBA for excel to display current date and Time?
Question Posted on 23 Aug 2021

Home >> VBA >> VBA in Excel >> Write down a code in VBA for excel to display current date and Time?

Write down a code in VBA for excel to display current date and Time?
There are two ways to display date and time in excel. Both of these are given below:-
(1)By using =NOW() function in excel cell where you need to enter current date.

Excel Now()

(2)Second is by using below VBA code in excel

Sub timeStampNow()
Dim ts As Date
With Selection
.Value = Now
.NumberFormat = "m/d/yyyy h:mm:ss AM/PM"
End With
End Sub

Here we need to call timeStampNow() where we need that on cell in excelsheet