Hi Skippy

use the NOW function

e.g.

MsgBox(Now)

or

Msgbox(Date & " " & Time)


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"skippy" wrote in message
...
am learning VB / Macros ... need a MsgBox which contains both the current
date and time ... I am able to do one or the other, but not both ... what
is
the syntax?

e.g. I was able to figure out MsgBox (Time) and MsgBox (Date)
but can not figure out how to get BOTH in the MsgBox