VBA Left
This is a text and video example of how to write a VBA Left function:
*************************************************************************************
Public Sub GetFirstName()
Dim strFirstName As String
strFirstName = Range("A2")
strFirstName = Left(strFirstName, 3)
Range("B2") = strFirstName
End Sub
*************************************************************************************
Now watch how it's done...
That's all, I hope it helped! If not, feel free to email me at erik [at] vbahowto [dot] com
|
Are you struggling to learn VBA?
If your answer to the above question is yes, then I strongly recommend that you check out these VBA Crash Course videos |
