user form / calander (2003 SP3)

Topic

New Reply

Good afternoon

In December I made a userForm on a WS and added a Calander control for ease of inputting dates, this still works fine but when I open the Calander it shows the day that I added it as default, ie. December 12th can I do anything to make it display the current date, I have looked at the properties and the Value is 12/12/2007 and when a click the 3 … next to it I get the screenshot below but I cannot see how to set it to the current date

Cheers

Steve

Reply | Quote

Replies

Steve

I think you need to set the value in code when you open the calendar form.

In the Open event you can add :

frmCalendar.calCalendar.Value = Date

changing the form and calendar object names as appropriate

Nick

Reply | Quote

Cheers Nick

Reply | Quote