userform combobox not showing percentage in pulldown

[DB73]

Hey guys,

i'm stuck and cant find the correct answer for me.

i made an excel userform with comboboxes.
the particular, cbx5, does not what i want

i use this to populate my cbx

ComboBox5.List = Application.Range("uur_tarief_percentage").value

its from a 1 column table
the values here are in percentage (condition format)

when i open my userform and klick the cbx, it shows not the values from the table as like "100%", it shows "1"
only after i select the "1" it populate the box with "100%

i know that actualy "100%" is "1", but i want it also shown in the pull down.
but i use this;

    Private Sub ComboBox5_Change()
    ComboBox5.Text = Format(ComboBox5.Text, "0,0%")
    End Sub

the next problem is that as i say ok write to sheet with the following code

'uur tarief percentage
    Sheets("dump stats").Range("S" & Rows.Count).End(xlUp).Offset(0, 0).value = ComboBox5.Text

it gonna be "1000%"
that causes a problem with calculation in other cells

i also tried to leave the conditional format just standard and use "100" but than i have to use this code;

=[@[Normaal tarief]]/100*[@[uurtarief percentage]]

instead of this;

=[@[Normaal tarief]]*[@[uurtarief percentage]]

cmb5 = uurtarief percentage.

all i want is that everyting is shown in "%"

 

[dmt32]

Hi,
Try using the Range.Text property to load your control with the formatted text of each cell in the Range & see if this resolves your issue.

        Dim cell As Range
        For Each cell In Application.Range("uur_tarief_percentage").Cells
          ComboBox5.AddItem cell.Text
        Next cell

Dave

 

[DB73]

Hi,
Try using the Range.Text property to load your control with the formatted text of each cell in the Range & see if this resolves your issue.

        Dim cell As Range
        For Each cell In Application.Range("uur_tarief_percentage").Cells
          ComboBox5.AddItem cell.Text
        Next cell

Dave

this is what i needed...thanks

 

[dmt32]

this is what i needed...thanks

welcome glad resolved your issue & appreciate feedback

Dave