How to find current date using VBA?

Let us see the procedure how to find Current Date using VBA Date and Format functions. 'Procedure to Get Current Date Sub VBA_Current_Date() 'Variable declaration Dim dDate As Date 'Get current date dDate = DateAdd(“d”, 0, Date) 'Or dDate = Date 'Display current date MsgBox “The current date is :” & dDate, vbInformation, “Get Current Date” End Sub
For More Information Please Refer:


You May Also Like to Read: