K
kizzie
Hello,
Does anyone know the command for adding the actual time and date to a
string?
thx in advance
Does anyone know the command for adding the actual time and date to a
string?
thx in advance
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
ScottO
How about ="String"&Text(Now(),"d/m/yyyy hh:mm")
Rgds,
ScottO
in message
|
| Hello,
|
| Does anyone know the command for adding the actual time and date to
a
| string?
|
| thx in advance
|
|
| --
| kizzie
| -------------------------------------------------------------------
-----
| kizzie's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=26092
| View this thread:
http://www.excelforum.com/showthread.php?threadid=394484
|
Rgds,
ScottO
in message
|
| Hello,
|
| Does anyone know the command for adding the actual time and date to
a
| string?
|
| thx in advance
|
|
| --
| kizzie
| -------------------------------------------------------------------
-----
| kizzie's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=26092
| View this thread:
http://www.excelforum.com/showthread.php?threadid=394484
|
B
Bob Phillips
If you mean VBA instaed, that is
myVar = "String" & Format(Now,"dd/mm/yyyy hh:mm:ss")
myVar = "String" & Format(Now,"dd/mm/yyyy hh:mm:ss")
D
dominicb
Good morning Kizzie
Do you mean within VBA? The code below will add the time in a
prescribed format to a text string, a.
Sub test()
a = "The time is " & Format(Now(), "hh:mm:ss")
MsgBox a
End Sub
HTH
DominicB
Do you mean within VBA? The code below will add the time in a
prescribed format to a text string, a.
Sub test()
a = "The time is " & Format(Now(), "hh:mm:ss")
MsgBox a
End Sub
HTH
DominicB
K
kizzie
thx , that did the job :