View Single Post
 
Old 01-30-2015, 01:35 AM
Attila Attila is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Jan 2015
Posts: 7
Attila is on a distinguished road
Default 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.
Reply With Quote