Userform - calendar control
 

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
--
HJN

Userform - calendar control
 

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

"Hennie Neuhoff" wrote in message
...
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
--
HJN

Userform - calendar control
 

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.


"Hennie Neuhoff" wrote:

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
--
HJN