Really basic VBA question...

[Ignition1]

Hi

I have a dog simple VBA string -

MsgBox (Date & Time)

How do I get a space between the Date and the Time? I've tried & "" and various other uses of " " including a Google search...doesn't seem to be documented anywhere.

P.S I know I can use the Now function but I just want to know for future ref.

 

[VoG]

Try

MsgBox Date & " " & Time

 

[Ignition1]

*face palm*

Thanks!

 

[Peter_SSs]

Also

MsgBox Date + Time

 

[Ignition1]

Even quicker, thanks Peter.