Percentage values in combobox userform

Hi all,

Question:

I have list of percentages in a range. The userform picks this up in a combobox.
In my sheet, the format is set to percentage and the numbers are entered as 0,05, 0,10, 0,15 etc. - So it's shown as 5%, 10%, 15% etc.

The combobox shows this as 0,05, 0,10, 0,15.
How can i let the combobox display this as 5%, 10%, 15%?

Thanks!

Hi,
When you add values to combobox try to format them, like this

Please Login or Register  to view this content.

Hi Kasan,

My Combobox is called Percentage.


The list now is:

Please Login or Register  to view this content.

However this results in a mismatch?

If you populate your combobox with List then you probably need to loop throw it and format each record after list is loaded in combobox:

Please Login or Register  to view this content.

Thanks Kasan!!