Set Calender date to today on userform

[MCE2014]

Hi,

I have a calender on my userform for the user to select a date.

Is there anyway to automatically have this date set to the current date when the user opens the userform?

They may want to choose a different date to the current date but the majority of the time it will be the current date that will be entered.

 

[svendiamond]

Yeah just use

=TODAY()

 

[MCE2014]

Here is the code i used from your recommendation:

frmDefects.caldate.Value = Today()

Im getting error: "Sub or function not defined"

 

[Gilliam]

in VBA its just
frmDefects.caldate.Value = Date