Present Time Enter using VBA

[KishorKK]

Hi All,


I would like to enter present time using VBA. Can anyone tell me i tried like this getting error "variable not found"

 

[KishorKK]

 

[Monty]

Hello Kishore..

Try this.

Sub test()
Dim dt as date
Dt=Date
Msgbox dt
End Sub

This msgbox gives u date n time...instead give cell references to display on excel sheet and format if i want only date.
Sorry Guys provided code for not giving in code mode.

 

[Chihiro]

Just use NOW instead.



Edit:
@Monty
Date will only return date (1/30/2017 for an example).
Now will have both date and time.

Edit2:
Alternately you can do something like below.

Sub Test()
Debug.Print Date + Time
End Sub

 

[Monty]

Chihiro

Thanks for the information...Noted!!!