I have two forms in an excel document, one has a textbox on, the othe
has a calendar control on it.
When I click a button on my excel sheet the first form opens, there i
a textbox with the text please enter date, and another button name
"Calender".
When you press "Calandar" it opens the calendar form. what I want t
happen is when I click on a date in the calender is for that value t
then appear in the inputbox on the first form.
I can get the calendar to put the date in a cell using the followin
code:
Private Sub Calendar1_Click()
Range("A4").Activate
ActiveCell = Calendar1.Value
ActiveCell.NumberFormat = "dd/mm/yy"
End Sub
But I need it to be in the text box on the first form
PLEASE HELP!!
Dav
--
Dave_2k
-----------------------------------------------------------------------
Dave_2k5's Profile:
http://www.excelforum.com/member.php...fo&userid=1966
View this thread:
http://www.excelforum.com/showthread.php?threadid=39452