如何使用EXCEL VBA求1-100相加累积的和

1、打开EXCEL，按Alt+F11键显示VBE。

3、输入代码：Sub qiuhe()Dim i As IntegerDim n As Integeri = 1n = 0For i = 1 To 100 n = n + i NextMsgBox nEnd Sub