Hello everybody.
I have a table in a sheet with percentages 10% 20% 30% .... 100% (simple)
But when i fill a combobox and a listbox it shows as 0.1 0.2 0.3 ....1
Somebody an idea so that de combobox and listbox shows the percentages.
Thanks in advance.
Hi Narayan,
I found a solution, so the problem is solved.
this is the code
Code:
With LB_02
.List = [Lijst].Value
.ColumnCount = [Lijst].CurrentRegion.Columns.Count
.ColumnWidths = "40;150;150;60;60;50;150;150;300"
For lindex = 0 To .ListCount - 1
.List(lindex, 5) = (Format((.List(lindex, 5)), "00%"))
Next
End With
But thank you for your quick responses.
Have a nice evening.