Because you have not specified the type of input variable, input box
defaults to a string so Input1 + Input2 is concatentating "2" + "2"
Change the Dim lines to
Dim Input1 as Double
Dim Input2 as Double
This tells VBA to expect a numerical value. Caution do not rely on this
method, if the user enters anything other than a numerical value you will
get an error.
Cheers
Nigel
"doc_in_bc " wrote in message
...
First Day Learning VBA for Excel. I've written the following sub
routine,
Option Explicit
Sub SunnyDay()
Dim Input1
Dim Input2
Dim Total
Input1 = InputBox("Enter the first amount!")
Input2 = InputBox("Enter the second amount!")
Total = Input1 + Input2
MsgBox "The total amount is " & Total
End Sub
Why does the Total Amount of 2+2 display as 22? If I change the
operators to * , / , or - , I get the correct arithmetic answer. With
the + I get concatenation instead of addition. Curious.
Cheers
Dodug
---
Message posted from http://www.ExcelForum.com/