calendar active x control

[andyjames]

I have created a calendar to appear when using another form to obtain a date. How do i transfer the date value from one form to another?

I would usually think that this would be done using ByRef but I am struggling to work out how this would be done.

 

[Richard Schollar]

Hi Andy

Just pass the value of the calendar to say a textbox on your second userform, something like:

UserForm2.TextBox1.Value = UserFormCalendar.Value

Depends obviously on what object you are wishing to populate, and also how the calendar is constructed.

 

[andyjames]

Thanks Richard

I am still having trouble with this.
I have a msgbox that shows that a date has been selected

MsgBox Calendar1.Value

but when i use this same variable in my other form it reverts back to the 'opening' date.

Travel_request.deptdate_label = frmCalendar.Calendar1.Value

{where travel_request is one userform and frmCalendar the other}

 

[Andrew Poulsom]

Here is an example:

http://www.mrexcel.com/board2/viewtopic.php?t=288002

 

[andyjames]

Thank you Andrew

Unfortunately this didn't work for me.
I don't think I understand modules well enough.

At the moment my main userform has most of the code behind it (and where I have added the 'userform1 module' code).

And the second userform (the calendar) has a little also (which is where I have added the 'userform2 module' code).

I have a single module (which is where I've added the 'general module' code).

I am not sure if i have explained what I have done very well, but have I made an obvious mistake?

 

[andyjames]

Please ignore my previous message.
I have found my error.
This works perfectly.
Thank you very much!!!!