View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TylerTheCoderGuy TylerTheCoderGuy is offline
external usenet poster
 
Posts: 4
Default 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