Percents in VBA

[billyshears]

Cell A1=a variable value

I have a userform that I can type numbers into. In the userform I type 10

I then want that number I entered in the userform to multiply Cell A1 by the userform number %

So if I type 10 in the userform, I want cell A1 to increase by 10%

If I type 5 into the userform, Cell A1 increases by 5%

I cant seem to get this working correctly. Do I format the text box in the userform as a %? or is this done in the VBA coding?

 

[rondeondo]

Hi Billy
your form is able to take anything as input, to make it robust you'll want to validate anything entered to be a number so the code doesn't break when someone types in their name. On your form label the field with a % after it so the user doesn't think they need to include the % symbol.
then in the VBA you want something like cells("A1").value = cells("A1").value * (1+<value from form)/100)