Formating a returned value

[Patrick Simonds]

I use a calendar control to input a date into a Table Cell in my document.

Selection.GoTo What: = wdGoToBookmark, Name:= "Date1a"
Selection.Text = Calendar1.Value

Is there any way to format this so instead of returning 06/16/2006, it
returns Sunday 16 July 2006

 

[Jezebel]

Selection.Text = format(Calendar1.Value, "dddd dd MMMM yyyy")

 

[Doug Robbins - Word MVP]

Use the Format function

Format(Calendar1,Value, "dddd dd MMMM yyyy")

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP