May I interject?

This example, with all apologies is bad form.

The 'corrected' version of this would be:

Sub MsgDateDate()
Dim BoxDate As String
Dim BoxTime As String
Dim BoxText As String

BoxDate = Date
BoxTime = Time
BoxText = BoxDate & vbCrLf & BoxTime

MsgBox BoxText

End Sub

Or just very simply:

MsgBox(Date & vbCRLF & Time)

No need to get overly complicated.


"Neil" wrote in message
...
Skippy,

The following bit of code should do what you want, if you don't want it on
two lines, just remove the CHR(13) part from the formula.

Boxdate = Date
Boxtime = Time()
boxtext = Boxdate & Chr(13) & Boxtime
MsgBox (boxtext)

HTH

Neil
www.nwarwick.co.uk

"skippy" wrote:

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