Office® XP Development with VBA

String-Processing Summary

Table 15.1 summarizes the string-manipulation statements and functions in VBA, based on the type of task they perform. Then, each of these statements and functions is covered separately in the chapter. Items are in alphabetical order.

Table 15.1. Summary of VBA's string-related statements and functions.

Task	Statement(s)/Functions(s)
Compare two strings	StrComp
Convert to lowercase or uppercase	LCase, UCase
Convert strings	StrConv, Str, Val
Create string of repeating character	Space, String
Display messages to user	MsgBox
Extract part of a string	Mid function, Left, Right
Find one string in another	InStr, InStrRev
Find length of a string	Len
Input text from user	InputBox
Insert one string within another	Mid statement
Set string comparison ...