Be the first user to complete this post

  • 0
Add to List

VBA-Excel: Date-Time Functions - Timer()

Description:

         The Timer() function returns the Number of seconds and MiliSeconds since 12:00 AM.

Format:

          Timer()

Example:

Function FnTimer()
   Dim intSeconds
   intSeconds = Timer
   MsgBox " No of seconds and MiliSeconds since 12:00 AM are-> " & intSeconds
End Function 
Timer()
Timer()



Also Read:

  1. VBA Excel - Cells, Ranges and Offset : Offset
  2. Excel-VBA : Range - Lock/Unlock Specific Cells
  3. VBA-Excel : 3D-Ranges – FillAcrossSheets Method
  4. VBA-Excel: Date-Time Functions – CDate()
  5. VBA-Excel : Strings Functions – Instr
  6. VBA-Excel: Date-Time Functions – DateSerial()
  7. VBA-Excel: Arrays – One Dimension, Dynamic Array
  8. VBA-Excel: Arrays – Multi Dimensional Array