MsgBox date & time
 

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

MsgBox date & time
 

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

MsgBox date & time
 

Use the Ampersand (&) to connect values. Ignore old example code online or
from old books using the + to connect values.

i.e. Msgbox(Time & " " & Date)


"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

MsgBox date & time
 

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

MsgBox date & time
 

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

MsgBox date & time
 

Well, if you want to discuss not getting overly complicated why not just

MsgBox Now

Or

MsgBox Date & " " & Time

(and the parentheses are not required either)


"Steve Schroeder" wrote:

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

MsgBox date & time
 

The second example I gave was just that, the uncomplicated version. You are
of course correct about the parentheses. Feel better? I know I do.

"Charlie" wrote in message
...
Well, if you want to discuss not getting overly complicated why not just

MsgBox Now

Or

MsgBox Date & " " & Time

(and the parentheses are not required either)


"Steve Schroeder" wrote:

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

MsgBox date & time
 

I was going to make that point, but in fairness to Steve, his example
include a line-break between (as did the one he was commenting on) between
the date and time, whereas yours does not.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Charlie" wrote in message
...
Well, if you want to discuss not getting overly complicated why not just

MsgBox Now

Or

MsgBox Date & " " & Time

(and the parentheses are not required either)


"Steve Schroeder" wrote:

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