Hello all,
I am using word 2003 proff. edit.
I have a form with a normal textbox on it. I am using the
UserForm_Initialize() to make the textbox initialize with the current date.
I do it this way:
Private Sub UserForm_Initialize()
Dim SystemDato
SystemDato = Date
Dato.Value = SystemDato
End Sub
When i use the code above, it put the value 22-11-2006 into the textbox. I
would like to change that to the following format 22.11.2006
I have tried working with the format function, but I just cant get it to
work at all.
Can someone guide me in the right direction?
Thanks for any help with this problem.
/Henrik.
jvmoorsel@gmail.com - 22 Nov 2006 11:05 GMT
Hallo Mr. Bif
try this:
systemdato = format(date,"dd.mm.yyyy")
Greetings
MR. BIF. schreef:
> Hello all,
>
[quoted text clipped - 21 lines]
>
> /Henrik.