If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
ho do i insert calendar into xls worksheet
|
#2
|
|||
|
|||
ho do i insert calendar into xls worksheet
halina, here is one way,
http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#3
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Paul,
I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#4
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Drahos
Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#5
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Ron,
you are right. Thanks a lot. Now one more question. I need to have in my form severel cells containing Calendar. The problem is these fields are not in a continuous range but they are on very different places. How can I do this. Now I am not sure but there should be about 8 cells containing calendar. Regards Drahos. "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#6
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Drahos
Change the Range If Not Application.Intersect(Range("A1:A20,C1,C5,D20"), Target) Is Nothing Then -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Ron, you are right. Thanks a lot. Now one more question. I need to have in my form severel cells containing Calendar. The problem is these fields are not in a continuous range but they are on very different places. How can I do this. Now I am not sure but there should be about 8 cells containing calendar. Regards Drahos. "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#7
|
|||
|
|||
ho do i insert calendar into xls worksheet
Ron;
I got the same error message that Drahos had. What do you mean with "Maybe the Calendar you have add to the worksheet is not named Calendar1". How and where can I change this name? Thanks in advance. Maperalia "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#8
|
|||
|
|||
ho do i insert calendar into xls worksheet
hi maperalia
If you go in Edit mode (button on the control toolbox toolbar) and select the calendar you can see the name in the formulabar. You can change it there also -- Regards Ron de Bruin http://www.rondebruin.nl "maperalia" wrote in message ... Ron; I got the same error message that Drahos had. What do you mean with "Maybe the Calendar you have add to the worksheet is not named Calendar1". How and where can I change this name? Thanks in advance. Maperalia "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#9
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Ron,
Thanks for displaying the information on how to load a calendar. I have a couple of questions if you can help please? Is there a way of when you click on the cell the calendar pops up to only select the date once via the mouse and the pop up calendar disappears rather than you clicking enter or clicking on other cell? Also I am having problems changing the date format to UK - I have changed this in the format cells section, but it reverts back to US version for each date selected? - Is there any way you can lock the format? Thanks "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#10
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Darren
Which Excel version do you use ? You have a protected sheet ? -- Regards Ron de Bruin http://www.rondebruin.nl "Darren" wrote in message ... Hi Ron, Thanks for displaying the information on how to load a calendar. I have a couple of questions if you can help please? Is there a way of when you click on the cell the calendar pops up to only select the date once via the mouse and the pop up calendar disappears rather than you clicking enter or clicking on other cell? Also I am having problems changing the date format to UK - I have changed this in the format cells section, but it reverts back to US version for each date selected? - Is there any way you can lock the format? Thanks "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert Picture Error | Lynda | Powerpoint | 19 | November 22nd, 2005 09:00 PM |
can you insert a comment into a protected worksheet? | TKGerdie | Worksheet Functions | 3 | October 18th, 2005 04:32 PM |
can I insert a calendar page into a Publisher brochure template? | Cheska99 | Publisher | 3 | September 22nd, 2005 09:26 PM |
Insert worksheet | Krish | General Discussion | 2 | July 12th, 2004 01:22 AM |
auto insert copy of worksheet | Bernie Deitrick | Worksheet Functions | 0 | March 4th, 2004 02:18 PM |