View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steve Schroeder Steve Schroeder is offline
external usenet poster
 
Posts: 15
Default 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