| Home |
| Search |
| Today's Posts |
|
#41
Posted to microsoft.public.excel.misc
|
|||
|
|||
ho do i insert calendar into xls worksheet
Tried that already, same result, even tried it unloading the calendar add-in
"Ron de Bruin" wrote: Close Excel Start Excel again and try the code from my site in a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... Thanks, but still no matter where I click in the sheet I get the same error 424 & highlights the line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width "Ron de Bruin" wrote: Calendar1 is the name of your calendar When you are in Edit mode you can see and edit the name in the formulabar on the left Be sure that it is named Calendar1 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... Still won't work for me, I'm not sure how to identify the range (it's column A) But clicking anywhere in the sheet after I have added your code to the worksheet gives me error 424. & highlights the line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width I don't know what I am doing wrong. "Ron de Bruin" wrote: Change the range in the code to the range with your date cells See also this note on my site Note: you can use this if your range is not one area If Not Application.Intersect(Range("A1:A20,C1,E1"), Target) Is Nothing Then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... I am trying to get the calendar to pop up everytime you are in the date column... to help the user get it in in the right format. Is that possible? "Ron de Bruin" wrote: Hi When you use the code from my page you only have to add the calendar to the worksheet with Insert Object Read the page again http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... How do you tell what the calendar is named? I tried just using calendar.... but that didn't work either. I folled the instructions on this page: http://www.fontstuff.com/vba/vbatut07.htm & then I inserted this code on the sheet: Private Sub Calendar1_Click() ActiveCell.Value = CDbl(Calendar1.Value) ActiveCell.NumberFormat = "mm/dd/yyyy" ActiveCell.Select End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Not Application.Intersect(Range("A1:A20"), Target) Is Nothing Then Calendar1.Left = Target.Left + Target.Width - Calendar1.Width Calendar1.Top = Target.Top + Target.Height Calendar1.Visible = True ' select Today's date in the Calendar Calendar1.Value = Date ElseIf Calendar1.Visible Then Calendar1.Visible = False End If End Sub . "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 ... |
|
#42
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ho do i insert calendar into xls worksheet
Send me your test workbook private and i look at it
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... Tried that already, same result, even tried it unloading the calendar add-in "Ron de Bruin" wrote: Close Excel Start Excel again and try the code from my site in a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... Thanks, but still no matter where I click in the sheet I get the same error 424 & highlights the line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width "Ron de Bruin" wrote: Calendar1 is the name of your calendar When you are in Edit mode you can see and edit the name in the formulabar on the left Be sure that it is named Calendar1 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... Still won't work for me, I'm not sure how to identify the range (it's column A) But clicking anywhere in the sheet after I have added your code to the worksheet gives me error 424. & highlights the line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width I don't know what I am doing wrong. "Ron de Bruin" wrote: Change the range in the code to the range with your date cells See also this note on my site Note: you can use this if your range is not one area If Not Application.Intersect(Range("A1:A20,C1,E1"), Target) Is Nothing Then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... I am trying to get the calendar to pop up everytime you are in the date column... to help the user get it in in the right format. Is that possible? "Ron de Bruin" wrote: Hi When you use the code from my page you only have to add the calendar to the worksheet with Insert Object Read the page again http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tmirelle" wrote in message ... How do you tell what the calendar is named? I tried just using calendar.... but that didn't work either. I folled the instructions on this page: http://www.fontstuff.com/vba/vbatut07.htm & then I inserted this code on the sheet: Private Sub Calendar1_Click() ActiveCell.Value = CDbl(Calendar1.Value) ActiveCell.NumberFormat = "mm/dd/yyyy" ActiveCell.Select End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Not Application.Intersect(Range("A1:A20"), Target) Is Nothing Then Calendar1.Left = Target.Left + Target.Width - Calendar1.Width Calendar1.Top = Target.Top + Target.Height Calendar1.Visible = True ' select Today's date in the Calendar Calendar1.Value = Date ElseIf Calendar1.Visible Then Calendar1.Visible = False End If End Sub . "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 ... |
|
#43
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ho do i insert calendar into xls worksheet
Hi Ron;
I sorry to bother you again, but I want to make work the calendar in other computer and does not work. I noticed that this computer does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". Can you tell me how can I add this calendar control in excel? Thanks in advance. Maperalia "Ron de Bruin" wrote: 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 ... |
|
#44
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ho do i insert calendar into xls worksheet
Hi maperalia
See my page http://www.rondebruin.nl/calendar.htm You find a link there where you can download the control -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Hi Ron; I sorry to bother you again, but I want to make work the calendar in other computer and does not work. I noticed that this computer does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". Can you tell me how can I add this calendar control in excel? Thanks in advance. Maperalia "Ron de Bruin" wrote: 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 ... |
|
#45
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ho do i insert calendar into xls worksheet
Ron;
Thanks for your quick respond. I have the program load it in the "P" drive. The calendar is working in all computers except one. This one does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". I wonder how can I load it in this computer to make run the program. Thanks. Maperalia "Ron de Bruin" wrote: Hi maperalia See my page http://www.rondebruin.nl/calendar.htm You find a link there where you can download the control -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Hi Ron; I sorry to bother you again, but I want to make work the calendar in other computer and does not work. I noticed that this computer does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". Can you tell me how can I add this calendar control in excel? Thanks in advance. Maperalia "Ron de Bruin" wrote: 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 ... |
|
#46
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ho do i insert calendar into xls worksheet
Cick on this link on my site and then read this
http://www.fontstuff.com/mailbag/qvba01.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Ron; Thanks for your quick respond. I have the program load it in the "P" drive. The calendar is working in all computers except one. This one does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". I wonder how can I load it in this computer to make run the program. Thanks. Maperalia "Ron de Bruin" wrote: Hi maperalia See my page http://www.rondebruin.nl/calendar.htm You find a link there where you can download the control -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Hi Ron; I sorry to bother you again, but I want to make work the calendar in other computer and does not work. I noticed that this computer does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". Can you tell me how can I add this calendar control in excel? Thanks in advance. Maperalia "Ron de Bruin" wrote: 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 ... |
|
#47
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ho do i insert calendar into xls worksheet
Ron;
Thank you help. I really appreciatte. Maperalia "Ron de Bruin" wrote: Cick on this link on my site and then read this http://www.fontstuff.com/mailbag/qvba01.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Ron; Thanks for your quick respond. I have the program load it in the "P" drive. The calendar is working in all computers except one. This one does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". I wonder how can I load it in this computer to make run the program. Thanks. Maperalia "Ron de Bruin" wrote: Hi maperalia See my page http://www.rondebruin.nl/calendar.htm You find a link there where you can download the control -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Hi Ron; I sorry to bother you again, but I want to make work the calendar in other computer and does not work. I noticed that this computer does not have the "calendar control" under the menu Insert/Object/Create New/"OBJECT TYPE". Can you tell me how can I add this calendar control in excel? Thanks in advance. Maperalia "Ron de Bruin" wrote: 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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
| Insert a new worksheet after subtotal | Excel Worksheet Functions | |||
| Insert comment in protected worksheet | Excel Worksheet Functions | |||
| Insert worksheet is greyed out, is there an option to turn it on? | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
