Homework Sourse311 NUMERICAL METHODS Write VBA code to add one increment of
3.11. (NUMERICAL METHODS) Write VBA code to add one increment of time DELTA_T for each cycle of a loop until the total time reaches P*DELTA_T, where P is a whole number representing the number of cycles. DELTA_T and P values are spreadsheet user input. The code is to report the final value back to the spreadsheet.
3.11. (NUMERICAL METHODS) Write VBA code to add one increment of time DELTA_T for each cycle of a loop until the total time reaches P*DELTA_T, where P is a whole number representing the number of cycles. DELTA_T and P values are spreadsheet user input. The code is to report the final value back to the spreadsheet.
3.11. (NUMERICAL METHODS) Write VBA code to add one increment of time DELTA_T for each cycle of a loop until the total time reaches P*DELTA_T, where P is a whole number representing the number of cycles. DELTA_T and P values are spreadsheet user input. The code is to report the final value back to the spreadsheet.
Solution
Dim DELTA_T As Integer
Dim P As Integer
Set DELTA_T=ActiveSheet.Range(\"A2\");
Set P = ActiveSheet.Range(\"A3\");
For index =DELTA_T To P*DELTA_T
DELTA_T =DELTA_T +1;
Next index
MessageBox.Show(DELTA_T)
