ComboBox Format Problem

  • Thread starter Thread starter CG Rosén
  • Start date Start date
C

CG Rosén

Good Evening Group,

My ComboBox1 is filled by the property: Sheet1!A1:A10

The Range("A1:A10") is formatted as numbers. The values in the
range are of the type 1,00 0,75 0,50 etc with comma as decimal sign.
When opening the ComboBox, the values are correctly shown with
the comma decimal. When I click to select a value it is shown with
the dot as decimal sign in the collapsed ComboBox. When I use the
Find Method with the ComboBox text as the lookup value, it will
not work due to comma/dot difference. Hoping for some help in this
matter.

Brgds

CG Rosén
 
Private Sub Combobox1_Click()
Combobox1.Value = Application.Substitute(Combobox1.Text,".",",")
end Sub
 
Back
Top