אלי;580533 Wrote:
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.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160549

Microsoft Office Help