DriedMangoes
New Member
- Joined
- Jun 3, 2018
- Messages
- 3
Please be nice to me, I'm trying to learn VBA/macros by my own again after 15 years of not doing it 
I know this is basic but huhuhu anyway.. I know how to change a value of a cell by a command button, but how do I change all of those values in one click of the command button. See my attached picture.
So I want to change the values of A1:I11 to become less 5% of their original value by clicking the "LESS 5%" button, and by clicking "Original Value", they will return to the original value I placed.

I know this is basic but huhuhu anyway.. I know how to change a value of a cell by a command button, but how do I change all of those values in one click of the command button. See my attached picture.

So I want to change the values of A1:I11 to become less 5% of their original value by clicking the "LESS 5%" button, and by clicking "Original Value", they will return to the original value I placed.