Guzzlr
Well-known Member
- Joined
- Apr 20, 2009
- Messages
- 982
- Office Version
- 2021
- Platform
- Windows
Code:
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
Last edited: