kim15m
New member
- Joined
- May 4, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I have the macro below which I want to modify so as to use MsgBoxes instead of inputBoxes...used here
I NEED TO PUT MSGBOXES FIRST ASK USER TO ENTER FIRST NUMBER
THEN LATER ASKING USER IF HE WANT TO ADD TWO MORE NUMBERS, IF USER SAYS YES, Macro should Add the new numbers, answer saved in worksheet, say "D1"
I will appreciate any help...
Code is...
Sub kim15m()
Range("C1").Formula = "=A1+B1"
answer = "yes"
While answer = "yes"
Range("A1").Value = Application.InputBox(Prompt:="Enter first value ", Type:=1)
Range("B1").Value = Application.InputBox(Prompt:="Enter second value ", Type:=1)
answer = Application.InputBox(Prompt:="Do you want to do this again??", Type:=2)
Wend
End Sub
I NEED TO PUT MSGBOXES FIRST ASK USER TO ENTER FIRST NUMBER
THEN LATER ASKING USER IF HE WANT TO ADD TWO MORE NUMBERS, IF USER SAYS YES, Macro should Add the new numbers, answer saved in worksheet, say "D1"
I will appreciate any help...
Code is...
Sub kim15m()
Range("C1").Formula = "=A1+B1"
answer = "yes"
While answer = "yes"
Range("A1").Value = Application.InputBox(Prompt:="Enter first value ", Type:=1)
Range("B1").Value = Application.InputBox(Prompt:="Enter second value ", Type:=1)
answer = Application.InputBox(Prompt:="Do you want to do this again??", Type:=2)
Wend
End Sub