You said
I have created a user form in excel.

the web page has an example of that. Read down.

--
Regards,
Tom Ogilvy

"na" wrote in message
...
The website you gave me would be helpful if I was not putting the calendar
in
a form but I am so I would need to see an example of that. Is there any
examples on the web?

Also what about the error I get when drawing the calendar (see original
post)


"Tom Ogilvy" wrote:

http://www.fontstuff.com/vba/vbatut07.htm

--
Regards,
Tom Ogilvy

"na" wrote in message
...
I have created a user form in excel. I would like to use the calendar
control for three of the text boxes as all will require dates.

My first issue is that when I am trying to draw the calendar control
I
get
the following error: Could not complete the operation due to error
800a0011.


My second issue is that while I am fine drawing objects onto the form
I
would just need to see an example of someone else who has done this
before
(created a form in excel with multiple fields that need a date and
having
the
calendar fill in those fields) - does anyone know of an example I
could
look
at? I am not VBA savy and this would help immensly.