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

Calendar and userforms
 

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

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

"אלי" 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

Calendar and userforms
 

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

"Sanjay" wrote:

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

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

"אלי" 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

Calendar and userforms
 

אלי;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