MS Word 2007 Forms/Templates

Microsoft Office word 2007
December 17, 2009 at 08:55:58
Specs: Windows XP
I've made a form with a Date Picker on it. Made it back in October. Now when I or someone uses the form and wants to pick a date, the calendar automatically opens to October 2009 so I have to use the arrows to forward it to December (or into the future). Is there a way for it to open up in the present month. Once we get into the latter half of next year it'll be a nuisance to forward the calendar all the way to the present date.

See More: MS Word 2007 Forms/Templates

Report •

December 17, 2009 at 10:24:50

I use a DatePicker in a custom form and I use this in the initialization code:

Private Sub UserForm_Initialize()
' Check if active cell contains a date. If 'yes' show
' same date on calendar. If 'no' show today's date.
    If IsDate(ActiveCell.Value) Then
        Calendar1.Value = DateValue(ActiveCell.Value)
        Calendar1.Value = Date
    End If
End Sub


Report •
Related Solutions

Ask Question