Calendar and userforms

[×לי]

Hi all!

I have a calendar control embedded in a userform and another 2 userforms
with few textboxes that call the calendar form. My question is how can I
direct the calendar value to the specific active textbox in one of the
userforms that needs the calendar value?

Thanks in advance

Eli

 

[Sanjay]

Hi,
Do refer to..
http://www.fontstuff.com/vba/vbatut07.htm

Regards,
Sanjay
Mark "Yes", if the post is helpful.

 

[×לי]

Thanks for your reply, but I can't found there anything regarding the use of
the calendar value and different textboxes in different userforms.


Eli

 

[p45cal]

Hi all!

I have a calendar control embedded in a userform and another 2
userforms
with few textboxes that call the calendar form. My question is how can
I
direct the calendar value to the specific active textbox in one of the
userforms that needs the calendar value?

Thanks in advance

Eli

With the likes of

Code:
--------------------
UserForm2.TextBox1.Value = UserForm1.Calendar1.Value
--------------------

As long as both userforms are loaded this should work in either of the
userfroms code modules. You could use it in the afterupdate event of the
calendar, or in the initialise event of userform2.. any number of
places.