How to incorporate a changing variable into a text Msgbox in VBA?

Question

I am currently trying to make a simple VBA program that would multiply two numbers together and then prompt a message box that says "The value of (variable1) and (variable 2) is (The answer).

Here is my current attempt that isn't perfect:

 MsgBox prompt:=intmlt, Title:="The Value of " & intFirstNum & intSecondNum

The two big issues I have is how to you put a space inbetween the intFirstNum and intSecondNum? and How do you add an is to the end of that prompt?

`"The Value of " & intFirstNum & " and " & intSecondNum & " is "` — Scott Holtzman, Feb 02 '16 at 18:57
THANK YOU! that worked perfectly. I was inverting the & and " at one point — Zack Withrow, Feb 02 '16 at 19:13

score 0 · Answer 1 · answered May 09 '17 at 23:33

0

It should be

"The Value of " & intFirstNum & " and " & intSecondNum & " is "

Per @ScottHoltzman

answered May 09 '17 at 23:33

0m3r

12,286
15
35
71

How to incorporate a changing variable into a text Msgbox in VBA?

1 Answers1