| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar error and include on form
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calendar error and include on form
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calendar error and include on form
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calendar error and include on form
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use RANDBETWEEN form & include certain #'s in the range | Excel Worksheet Functions | |||
| Add calendar to VBA User Form | Excel Discussion (Misc queries) | |||
| how do I creat an input form in excel 2007 to include drop down bo | Excel Discussion (Misc queries) | |||
| find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
| Printing Form to Include All Options in Excel | New Users to Excel | |||
Linear Mode
