Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Format Problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Format Problem
Private Sub Combobox1_Click()
Combobox1.Value = Application.Substitute(Combobox1.Text,".",",") end Sub -- Regards, Tom Ogilvy "CG Rosén" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox problem | Excel Discussion (Misc queries) | |||
Combobox problem | Excel Programming | |||
Complex Combobox problem . | Excel Programming | |||
Activation combobox problem. | Excel Programming | |||
ComboBox Problem | Excel Programming |