Use command button to enter todays date

nicktheblue

Registered User.
Local time
Today, 14:47
Joined
Sep 15, 2001
Messages
18
Hello forum,

can anybody tell me the code I should attach to a command button to have it insert 'today's' date into a field? I'm sure everybody either:
a)Knows what it is
or
b)Would find it incredibly useful!

Many thanks in advance,

Nick
 
Sorry,

just answered my own question by searching the forum...

Private Sub Command120_Click()
Lastattended.Value = Date
End Sub

Thanks all the same!
 
You can also press ctrl & the semi colon keys together. (This also works in excel)
 

Users who are viewing this thread

Back
Top Bottom