% Sign to Show on a User Form

[Guzzlr]

Private Sub Percent_Button_Click()
On Error GoTo ErrorHandler

Percent_Input = 1 - (REV_Input / Budget_Input)
Selection.Style = "Percent"
Exit Sub
    
ErrorHandler:
MsgBox ("Both REV and Budget Fields Must Have a Number Input")

End Sub

Hello All,
I have an annoying problem here with my user form. Above is my code so when I select the Percent Button, the corresponding field should show a number with the percent sign. For example, if I have REV_Input as 5, and Budget_Input as 10, the Percent_Input field keeps showing .5...instead of 50%, like I would like. How do I get the % sign to show in the corresponding user form field?
Thanks for the help
excel 2013

 

[Norie]

Use the Format function.

Percent_Input = Format(1 - (REV_Input / Budget_Input), "0%")