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!

VBA Code Examples Add-in

Easily access all of the code examples found on our site.

Simply navigate to the menu, click, and the code will be inserted directly into your module. .xlam add-in.

(No installation required!)

Free Download

Return to VBA Code Examples