- 01Setting up (what you'll need)
- 02Your first output (MsgBox)
- 03Variables (Dim)
- 04Branching (the If statement)
- 05Repeating (the For statement)
- 06Repeating (the Do While statement)
- 07Writing a Sub procedure
- 08Function procedures (work that returns a value)
- 09Reading and writing cells (Range and Cells)
- 10Working with arrays
- 11Working with strings
- 12The With statement
- 13Object variables and working with worksheets
- 14Looping over cells (For Each)
- 15Error handling (On Error)
- 16The Select Case statement
- 17Arguments (ByVal and ByRef)
- 18Working with collections (Collection)
- 19Recording macros and event procedures
- 20[Project] Build a small inventory sheet
Working with strings
This lesson covers basic string handling in VBA.
Built-in functions are provided such as Len (character count), UCase (upper case), and Left (a substring from the left).
The sample code checks the character count with Len(message) and takes the first five characters with Left(message, 5).
A common early stumble is that these are standalone functions rather than method calls. You cannot write message.Len() — it is Len(message).
In professional work, string handling — tidying and validating the data entered into cells — is essential in practically every macro.
๐งช This site can't compile or run VBA directly, so it checks on the spot whether what you typed matches the reference code (scoring happens entirely in your browser โ nothing is sent anywhere).