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
...