Items in combo box have different formatting than souce cell

[crocco]

I am populating a combo box with a cell range of percentages.

When the items are shown in the dropdown list they are decimals rather than the percentage format of the source cell. ie one of the items in the source cell range is 3.75% but in the actual dropdown it shows as 0.0375.

Is there anyway to make it show 3.75% in the dropdown as well? I am using an ActiveX xombo box.

Thanks

 

[Sektor]

Use Format(0.0375, "0.00%").

 

[MickG]

Add this to the Combobox CHange event:-

Private Sub ComboBox1_Change()
ComboBox1.Value = Format(ComboBox1, "0.0%")
End Sub