Concatenation Operator


This concatenates two operands together.

 MsgBox "Richard " & "Shepherd" 

This gives the result ‚“Richard Shepherd. ‚½ Note that a space was left at the end of "Richard " to give the space in the final string.

You can also concatenate numbers and strings, but remember that the result will be a string. The following gives the result ‚“12 Twelve ‚½:

 Msgbox 12 & " Twelve" 

The following gives the result 34, but as a string not a number:

 Msgbox 3 & 4 



Excel VBA Macro Programming
Excel VBA Macro Programming
ISBN: 0072231440
EAN: 2147483647
Year: 2004
Pages: 141

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net