Return Value from DTpicker into DocVariable in Word
Hello there..
I have several Comboboxes and Textboxes in my UserForm all of them are returning correctly into my DocVariables.
The code I used to return Textbox Value to the Variable is:
ActiveDocument.Variable("var1") = Textbox1.value
I tried now to do the same with the DTPicker
ActiveDocument.Variable("var2") = DTPicker.value
But it returns either 00:00:00 or 30 0000 2015.
I tried to format the DTPicker with the code:
DTPicker = Format(DTPicker,"dd mmmm yyyy")
Also I tried to change the Variable to:
{DocVariable var2 \@ "dd mmmm yyyy"}
Each way didn't work. So please can somebody help me.
|