For i = 1 To Val(Text1)
Sum = Sum + 1 / Val(InputBox("請輸入阻值"))
Next
MsgBox "並聯後的阻值" & 1 / Val(Sum)
End Sub