Hello,
I'm trying to add a VBA code into a tool I'm creating for my thesis since the calculation is a repeatable calculation, although a lot of work to do by hand.
Perhaps one of you guys is able to help me out on this.
In my main worksheet "Resistance", I added a form control button where the macro is supposed to be assigned to.
What it should do...
1. It must select cell D7 in another worksheet called "Sav. paper" (this cell contains is a speed value, upcoming calculations are based on this value);
2. Cell D7 should start at a value of 10;
3. In cells B50:H50 the answers are given for the calculations with the speed of cell D7.
4. These answers need to be pasted as values into cells I50:O50
5. Select cell D7 and set the value of 10 to a value of 10.5 (speed is in steps of 0.5)
6. Answers given to this speed value end up in cells B51:H51
7. These answers need to be pasted as values into cells I51:O51
8. Select cell D7 and set the value of 10.5 to a value of 11
9. Answers given to this speed value end up in cells B52:H52
10. These answers need to be pasted as values into cells I52:O52
And so on until cell D7 has reached a speed value of 55...
It seems quite simple, but I'm unable to fix this code by myself..
If there are suggestions to even do this quicker, all are welcome!
Thanks already!
I'm trying to add a VBA code into a tool I'm creating for my thesis since the calculation is a repeatable calculation, although a lot of work to do by hand.
Perhaps one of you guys is able to help me out on this.
In my main worksheet "Resistance", I added a form control button where the macro is supposed to be assigned to.
What it should do...
1. It must select cell D7 in another worksheet called "Sav. paper" (this cell contains is a speed value, upcoming calculations are based on this value);
2. Cell D7 should start at a value of 10;
3. In cells B50:H50 the answers are given for the calculations with the speed of cell D7.
4. These answers need to be pasted as values into cells I50:O50
5. Select cell D7 and set the value of 10 to a value of 10.5 (speed is in steps of 0.5)
6. Answers given to this speed value end up in cells B51:H51
7. These answers need to be pasted as values into cells I51:O51
8. Select cell D7 and set the value of 10.5 to a value of 11
9. Answers given to this speed value end up in cells B52:H52
10. These answers need to be pasted as values into cells I52:O52
And so on until cell D7 has reached a speed value of 55...
It seems quite simple, but I'm unable to fix this code by myself..
If there are suggestions to even do this quicker, all are welcome!
Thanks already!