Concatenate result of InputBox with a prefix and a suffix.

I have an InputBox that is asking for a text string. (InputBoxVal).  How come when I try and concatenate the value with something else it does not want to?
The result I am looking for is: Summary##[whatever InputBoxVal is]##    so if I typed in the InputBox  "EE-Rocks"  the result would be:  Summary##EE-Rocks##

InputBoxVal = InputBox("Please enter and breif Summary for this ticket")
        .Body = .Body & "Summary##"&InputBoxVal&"&"##" & Chr(10)

Open in new window


What am I doing wrg in Ln2?
It it putting a line into the body of an email...  Please advise and thanks.
RWayneHAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
It should be...
"Summary##" & InputBoxVal & "##"

Open in new window

0
 
RWayneHAuthor Commented:
yup, worked perfect....  I always have issues with concatenating.  Thanks for the help.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome!
While concatenating, all you need is to place the constant strings within double quotes followed by a space followed by & followed by another space and then your variable. :)
0
 
RWayneHAuthor Commented:
PS:  What happens if I click on the "Request Live Session"?  Is that a paid session?  What if we have an annual account...?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Live session is a paid session where you buy the time as per the hourly rate set by the expert.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.