Need Help Summing with Input Box

[shivahsingh]

This is what I have So far

price = InputBox(prompt:="Enter Price of Pencils") + price = InputBox(prompt:="Enter Price of Pens") + price = InputBox(prompt:="Enter Price of Erasers") + price = InputBox(prompt:="Enter Price of Backpack")




Result = "The total you will pay is" & price
MsgBox Result


i want the user to enter the prices and then the sum will be displayed in a messagebox as currency

 

[VoG]

Try

Price = InputBox(prompt:="Enter Price of Pencils")
Price = Price + InputBox(prompt:="Enter Price of Pens")
Price = Price + InputBox(prompt:="Enter Price of Erasers")
Price = Price + InputBox(prompt:="Enter Price of Backpack")
Result = "The total you will pay is " & Price
MsgBox Result

 

[shivahsingh]

Thank you very much, that worked!, i still cant get my price to display as currency, I declared dim price as currenncy but displays as an interger

 

[VoG]

Try

Result = "The total you will pay is " & Format(Price, "$0.00")