Link to home
Start Free TrialLog in
Avatar of RWayneH
RWayneHFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RWayneH

ASKER

yup, worked perfect....  I always have issues with concatenating.  Thanks for the help.
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. :)
Avatar of RWayneH

ASKER

PS:  What happens if I click on the "Request Live Session"?  Is that a paid session?  What if we have an annual account...?
Live session is a paid session where you buy the time as per the hourly rate set by the expert.