RWayneH
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##
What am I doing wrg in Ln2?
It it putting a line into the body of an email... Please advise and thanks.
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)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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. :)
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. :)
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.
ASKER