Thread: [Solved] Adding current time to VBA
View Single Post
 
Old 01-13-2018, 02:22 AM
blackroz blackroz is offline Windows XP Office 2007
Novice
  
Join Date: Nov 2015
Posts: 5
blackroz is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
You could just change:
strDate = Format((Date), "dd MMM yyyy")
to, say:
strDate = Format(Now, "dd MMM yyyy @ hh mm ss")
I added but it shows 00 00 00
Reply With Quote