Userform - calendar control

[Hennie Neuhoff]

I've got a userform with a calendar control - it works perfect with one
exception - I would like the calendar to show todays date as default [indent
or whatever].
My efforts thusfar resulted in the userform giving todays date irrespective
the date you choose - if I use Userform11.Calendar1.today
Any ideas ?
thanks in advance

 

[Doug Glancy]

HJN,

The default of the calendar, when first opened, is today's date, and that
sounds like what you want.

"Userform11.Calendar1.Today" sets the calendar to today's date

When the user picks a date, you can retrieve it with
Userform11.Calendar1.Value

hth,

Doug

 

[dunnerca]

I'm not sure if I fully understand your question but it sounds like you have
to save the value chosen by the user to a variable that your userform would
show. For example, something like

var_chosen=me.calendar.value

Then have the userform display var_chosen.

Sorry if I've misunderstood your question.