using the calendar on a userform
 

wsMyWorksheet.Range("C7") = Me.Calendar1.Value
I need to have this take affect as soon as the user select a day on the
calendar. I tried putting it in
Calendar1_Exit()
Calendar1_Afterupdate()
Calendar1_Click()
....if in Calendar1_Click(), it will update the cell if the user clicks
somewhere else (in anther textbox), but if they click on a tab strip that
moves to a different userform, the date wasn't set in the cell...