Solved: Calendar Control question

[lhardee]

Hello,


I would like to open a calendar control on my form to automatically select 14 days out from the current date.

Any assistance would be greatly appreciated.

Thanks,

lhardee

[lhardee]

I found it !

[VBA]

Private Sub UserForm_Activate()

Calendar1.Value = (Date + 14)

End Sub


[/VBA]




Thanks

lhardee

[lucas]

FYI discussion on the problems you might encounter using the calendar control:

http://www.vbaexpress.com/forum/showthread.php?t=10914

[lhardee]

Thanks a bunch Lucas,

I've saved a few things from that discussion that are a big help!



lhardee