Below is the code for what you are trying to do:
Dim numNumbers As Integer
Dim total As Double
numNumbers = InputBox("Please enter the number of numbers you would like to add", "Number of Numbers")
Dim counter As Integer
For counter = 1 To numNumbers
total = total + InputBox("Please enter number " & counter, "Number " & counter)
Next
MsgBox("The total is " & total, MsgBoxStyle.OkOnly, "Total")
This code uses InputBoxes for input and MsgBoxes for output. Also, this code has no error handling; therefore, if someone types something other than a number, then there is an error. The key to this is to not have the program store each number individually but only the total; once the number is added to the total, there is no need to remember the number.