Problem formatting decimals in ComboBox
I just realized that my code works in the English (United States)
Language Region formatting, but it is giving me errors when I switch to
German Language Region.
TylerTheCoderGuy wrote:
Hello,
I have the following line of code in the UserForm_Initialize() section
to show a 3-decimal placeholder in the selected item of the combobox:
comboBox1.Text = FormatNumber((Worksheets("Worksheet1").Cells(13,
5).Value), 3)
I am getting the error message: "Run-time error '380': Could not set
the Text property. Invalid property value."
Does anybody have any ideas as to what would be causing this error?
Best regards,
Tyler
|