Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use the Calendar control to fill in dates on de Bruin (last update 19 April 2004)
As instructed I have righ clicked sheet1 tab and cliked view code and copied
the code given in the webpage. But when I select any ceall in the range A1 to A20 the code stops at this line calendar1.Left = Target.Left + Target.Width - calendar1.Width If I click an;y cell other than A1:A20 the code stops at Else: calendar1.Visible = False In both case the error messate is "object required" I DONT KNOW WHAT MISTAKE I AM DOING mine is EXCEL 2000. i have not protected the sheet or workbook. Rond de Bruin's webpage is http://www.rondebruin.nl/calendar.htm |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use the Calendar control to fill in dates on de Bruin (last update 19 April 2004)
Hi
calendar1 is the name of the calendar. Maybe yours is calendar2?? -- Regards Ron de Bruin http://www.rondebruin.nl "R.VENKATARAMAN" &&& wrote in message ... As instructed I have righ clicked sheet1 tab and cliked view code and copied the code given in the webpage. But when I select any ceall in the range A1 to A20 the code stops at this line calendar1.Left = Target.Left + Target.Width - calendar1.Width If I click an;y cell other than A1:A20 the code stops at Else: calendar1.Visible = False In both case the error messate is "object required" I DONT KNOW WHAT MISTAKE I AM DOING mine is EXCEL 2000. i have not protected the sheet or workbook. Rond de Bruin's webpage is http://www.rondebruin.nl/calendar.htm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use the Calendar control to fill in dates on de Bruin (last update 19 April 2004)
thanks. shall try with "calendar2"
Ron de Bruin wrote in message ... Hi calendar1 is the name of the calendar. Maybe yours is calendar2?? -- Regards Ron de Bruin http://www.rondebruin.nl "R.VENKATARAMAN" &&& wrote in message ... As instructed I have righ clicked sheet1 tab and cliked view code and copied the code given in the webpage. But when I select any ceall in the range A1 to A20 the code stops at this line calendar1.Left = Target.Left + Target.Width - calendar1.Width If I click an;y cell other than A1:A20 the code stops at Else: calendar1.Visible = False In both case the error messate is "object required" I DONT KNOW WHAT MISTAKE I AM DOING mine is EXCEL 2000. i have not protected the sheet or workbook. Rond de Bruin's webpage is http://www.rondebruin.nl/calendar.htm |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use the Calendar control to fill in dates on de Bruin (last update 19 April 2004)
Select the calendar in the Design mode and you can see the name
in the formula bar on the left -- Regards Ron de Bruin http://www.rondebruin.nl "R.VENKATARAMAN" &&& wrote in message ... thanks. shall try with "calendar2" Ron de Bruin wrote in message ... Hi calendar1 is the name of the calendar. Maybe yours is calendar2?? -- Regards Ron de Bruin http://www.rondebruin.nl "R.VENKATARAMAN" &&& wrote in message ... As instructed I have righ clicked sheet1 tab and cliked view code and copied the code given in the webpage. But when I select any ceall in the range A1 to A20 the code stops at this line calendar1.Left = Target.Left + Target.Width - calendar1.Width If I click an;y cell other than A1:A20 the code stops at Else: calendar1.Visible = False In both case the error messate is "object required" I DONT KNOW WHAT MISTAKE I AM DOING mine is EXCEL 2000. i have not protected the sheet or workbook. Rond de Bruin's webpage is http://www.rondebruin.nl/calendar.htm |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use the Calendar control to fill in dates on de Bruin (last update 19 April 2004)
sorry my mistake. the control "calendar" was not activated in my excel.
that was the problem. it is only calendar1 thanks for helping me. Ron de Bruin wrote in message ... Hi calendar1 is the name of the calendar. Maybe yours is calendar2?? -- Regards Ron de Bruin http://www.rondebruin.nl "R.VENKATARAMAN" &&& wrote in message ... As instructed I have righ clicked sheet1 tab and cliked view code and copied the code given in the webpage. But when I select any ceall in the range A1 to A20 the code stops at this line calendar1.Left = Target.Left + Target.Width - calendar1.Width If I click an;y cell other than A1:A20 the code stops at Else: calendar1.Visible = False In both case the error messate is "object required" I DONT KNOW WHAT MISTAKE I AM DOING mine is EXCEL 2000. i have not protected the sheet or workbook. Rond de Bruin's webpage is http://www.rondebruin.nl/calendar.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to display the excel atcive control calendar to enter dates | Excel Discussion (Misc queries) | |||
Using Calendar control to display dates | Excel Discussion (Misc queries) | |||
Hyperlink from dates in Calendar Control 11.0 | Excel Discussion (Misc queries) | |||
How do I update calendar control 8.0 to 10.0 | Excel Programming | |||
Repost: Calendar Control: Ron De Bruin | Excel Programming |