View Single Post
  #2 (permalink)  
Old October 27th, 2004, 03:40 AM
BrianB BrianB is offline
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote