I have a ComboBox on the sheet, it takes its range of data from a list of dates. After I choose a date from the combobox, the value of the ComboBox change into numeric, I tried the below code but I got an error:
Private Sub ComboBox1_Change()
Me.ComboBox1.Value = Format(Me.ComboBox1.Value, "dd/mm/yy")
End Sub
Private Sub ComboBox1_Change()
Me.ComboBox1.Value = Format(Me.ComboBox1.Value, "dd/mm/yy")
End Sub