Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Msgbox - Puting current date in a message box | Excel Programming | |||
elapsed time in msgbox | Excel Programming |