Hi all,

I'm trying to use the calendar control to change the caption on
label.

I have one form containing the label.
I have another form with the calendar control on, and I want excel t
return the value from the form with the calendar control object to th
form with the label.

Why doesn't this work???

Private Sub Calendar1_Click()
stDeadline = Calendar1.Value
frmcalendar.Hide

With frmNytProjekt
Label10.Caption = stDeadline
End With

End Sub

Cheers

Steff_D

--
Message posted from http://www.ExcelForum.com