I tried the following in the Combobox change event (in ActiveX Controls) to format the input to a numeric format with 2 decimal places. However, it is not worked. Please help.
Private Sub ComboBox1_Change()
ComboBox1.Text = Format(ComboBox1.Value, "#,##0.00")
End Sub
Daniel
Private Sub ComboBox1_Change()
ComboBox1.Text = Format(ComboBox1.Value, "#,##0.00")
End Sub
Daniel