macro question

[ayushkapoor665]

how to make a macro that ask for input of two numbers and from the user and do the addition of those numbers
requirement:--
two dialog box asking for the input

thnks and regards
ayush kapoor

 

[VoG]

Try like this

Sub add()
Dim x, y, z
x = Application.InputBox("Enter first number", Type:=1)
y = Application.InputBox("Enter second number", Type:=1)
z = x + y
MsgBox z
End Sub

 

[JackDanIce]

Welcome to the board.

Something like:

Sub PurpleMineField ()
Dim a as Integer, b as Integer
Dim msg As String
msg = "Please enter your"
a = InputBox(msg & " first number: ")
b = InputBox(msg & " second number: ")
MsgBox "The sum of " & a & " and " & b & " is: " & vbCrLf & vbCrLf & a + b
End sub

 

[ayushkapoor665]

thanku it was a great help