Input box to sum and display sum as msgbox

Hello I am struggling to make this assignment happen:Create a macro procedure that asks for three integers (one at a time) and displays their sum in a message box.
Insert a module into the project, then insert a macro procedure named AddThreeNumbers. Code this procedure so that when it is executed, it will ask for three integers (one at a time), store them into three variables respectively, computes their sum, and display “The sum of [1st num], [2nd Num], and [3rd Num] is [the sum of the three numbers].” where each square bracket should be replaced by the numbers that the user put in. That is, if the user put in 10, 20, and 30 into the three boxes, it should display “The sum of 10, 20, and 30 is 60.” Make sure you declare and use appropriate variables.
1. The message box should have the title, “My Own Adder”.
2. Insert an ActiveX Command button displaying a picture of your choice, with the caption, “I Add Three Integers.”
3. Link the AddThreeNumbers procedure to the button so that when the button is clicked, the procedure is executed.
4. Save and submit the workbook.
I currently have this code but my input boxes are not being saved as a variable.

Please Login or Register  to view this content.

Now I am getting an error message in my msgbox code when I add the Sum function. Addtionally, I still get the words "myValue..." in the message box not the numbers entered into the inputbox.

This reads a lot like a homework or learning task.. so I will help you along the way but wont give the solution.

Remember your basic math, it still applies in VBA...
& will not sum anything & will just combine 2 strings into 1.

you will need to make an actual calculation to get the sum and then show that as a result in the messagebox
the 3 variables that store the results of the inputboxes is a good start..

Hello alexWhit21,

I fully agree with Roel Jongman, and echo everything he says.

Good luck.

Thank you for adding Code Tags!

I'll also agree with both of the above! So as for a little more help...

Open your Locals window from the view menu and step through your code with F8. You'll see that your variables do populate as expected. So perhaps the issue may be in how you are referring to your variables. Also you should go to a spreadsheet, type ="A1" in a different cell and see what result that gives you, and is it what you'd expect; and if not, why might that be? Finally, a bit cryptic but, what makes a number a number?... why can we do 1+1 but not one+one?

Alex,

What code doe you have so far ?

Also use Application.Inputbox with which you can control the input.

OK, to summarize.
Text goes between double quotes. Variables don't need to be double quoted. Text and variables are concatenated by the Ampersand eg &.
If avalable I use the application version of a worksheetfunction because when running code with the Worksheetfunction and an error arises your code goes into Debug while
using the application version your code runs further but you can trap the error using IsError.
That being said here's something to study on.

In a worksheet module.

Please Login or Register  to view this content.

In a standard module.

Please Login or Register  to view this content.