I have tried this and keep getting a Type Mismatch error on the section
Code:
cboGetDate.Text = CLng(Format(cboGetDate.Value, "dd/mm/yyyy"))
When I hover over it on the Debug it shows me the date as a number still
Code:
Private Sub cboGetDate_Change()
'cboGetDate.Text = Format(cboGetDate.Text, "dd/mm/yyyy")
cboGetDate.Text = CLng(Format(cboGetDate.Value, "dd/mm/yyyy"))
End Sub
Where am I going wrong?
|