Private Sub Calendar1_Click()
ActiveCell = TextBox1 'Calendar1.Value -this wqs tried but didn't work.
ActiveCell.NumberFormat = "mm/dd/yy"
Private Sub userform_activate()
Me.Calendar1.Value = Date
I want to insert a date selected from vba calendar into textbox1 located on a userform. which will later be inserted into the spreadsheet with a submit command on userform. The above code doesn't work. Please help. Thanx.