billyshears
Board Regular
- Joined
- Aug 29, 2013
- Messages
- 61
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?
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?