Hi John,

Do you have a reason for not putting the Calendar control in the same form
as the ComboBox?

Assuming that you do, in the Userform2's Calendar click event, add :

UserForm1.Date1.Value = Me.Calendar1.Value


---
Regards,
Norman



"johncassell"
wrote in message
...

hello,

I have 2 forms one for basic stock item details and the other is the vb
calender.

When clicking the calender i would like it to populate my combobox
"date1.text".

when i am in my stock item form and i'm editing code i can press
ctrl+spacebar and it will give me a list of valid objects (including my
date1 box) but when i am editing the calender code all the boxes from my
other form aren't there.

Ultimately, when running the calender with "date1.text" in the code,
there are errors.

I am sure this is a schoolboy error and would appreciate some
education!!

thanks in advance for your help

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile:
http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=391689