p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   UserForm - Calender control (http://p2p.wrox.com/showthread.php?t=20298)

venky October 23rd, 2004 10:53 AM

UserForm - Calender control
 
Hi,

Am creating a userform and added calender control.
Need to get the "Value" upon a date selection from the calender and put it into the active worksheet.

Need some help on this.
Thanks.


BrianB October 27th, 2004 03:40 AM

In theabsence of another reply .. I use a Microsoft Calendar Control, but it might be different to yours. The method here is to see what the names of the textboxes are via Properties and use them as follows :-
Code:

Sub Button1_Click()
    frmCalendar.Show
    ActiveSheet.Cells(1, 2).Value = frmCalendar!txtFrom.Value
    ActiveSheet.Cells(2, 2).Value = frmCalendar!txtTo.Value
End Sub

-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.


All times are GMT -4. The time now is 10:37 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.