3.11. (NUMERICAL METHODS) Write VBA code to add one increment of time DELTA_T fo

Question

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.

Explanation / Answer

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)

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.