PDA

View Full Version : Solved: Calendar Control question



lhardee
12-06-2008, 08:15 AM
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
12-06-2008, 08:31 AM
I found it ! :rotlaugh:



Private Sub UserForm_Activate()

Calendar1.Value = (Date + 14)

End Sub







Thanks

lhardee

lucas
12-06-2008, 09:11 AM
FYI discussion on the problems you might encounter using the calendar control:

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

lhardee
12-06-2008, 11:28 AM
Thanks a bunch Lucas,

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

:thumb

lhardee