In this example we use the "Now()" function to get the time and date now,
we then reassign the variable as "Time" which just assigns the time.
Sub a4_5_Date()
Dim x As Date
x = Now()
MsgBox x
x = Time
MsgBox x
End Sub
Related Sections
Python - Learn the python from the basics up. This fast track example code course will get you creating powerful python programs in no time.Must Read Articles
VBA and Microsoft Excel - Getting the most out of excel with VBA programming
VBA and Microsoft Word - Getting the most out of word with VBA programming
Application Object - Using the applications features in your code.
Installing VBA and First Program - What do you need to start using visual basic application VBA.