Return to VBA Code Examples

VBA Time Function

Time Description

Returns the current system time.

Simple Time Examples

Here is a simple Time example:

Sub Time_Example()
    MsgBox Time
End Sub

This code will return the current system time.

Time Syntax

In the VBA Editor, the syntax for the Time function.


The Time function contains no arguments:

Examples of Excel VBA Time Function

Dim CurrentTime
CurrentTime = Time

In this example, the current system time will be assigned to the variable “CurrentTime”.

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users! vba save as

Learn More!