Excel Form Dropdown List Format Issues

[rgarrity]

I have an form (Userform1) with a dropdown list. I want the user to select an inflation rate; the dropdown lists is therefore populated with a named range in another sheet. The values in this named ranged are formatted as percentages (e.g., 1.0%, 1.1%, 1.2%, 1.3%, etc., with the range from 0.1% to 10.0%). When the user clicks on the dropdown arrow, the values are displayed properly, however, after the user makes a selection, the value is displayed as a decimal, not a percent. In other words, if the user selects "3.0%" the value is displayed as "0.03." I want the field to reflect 3.0%.

I am at a loss as to how to correct this. Any help would be appreciated.

<tbody>
</tbody><colgroup><col></colgroup>

 

[Fluff]

try

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

 

[rgarrity]

Worked like a charm; thanks for the prompt reply!.

 

[Fluff]

Glad to help & thanks for the feedback

 

[rgarrity]

A related question....how can I use the same technique to format for currency (US)?

 

[Fluff]

Try

Private Sub ComboBox1_Change()
    ComboBox1.Value = Format(ComboBox1.Value, "$#,##0.00")
End Sub