Hi-
I have a userform that asks the user to enter a percentage. I have code that takes the value (i.e. 10) and formats it to 10% in the textbox:
MakePercent = Format(RawValue / 100, "#%")
However, when I need to multiply that percent value later in the code, it won't let me as I it reads the formatted value as a string.
How do I format it as a percentage, yet, have it remain a numeric value?
Thanks!
I have a userform that asks the user to enter a percentage. I have code that takes the value (i.e. 10) and formats it to 10% in the textbox:
MakePercent = Format(RawValue / 100, "#%")
However, when I need to multiply that percent value later in the code, it won't let me as I it reads the formatted value as a string.
How do I format it as a percentage, yet, have it remain a numeric value?
Thanks!