VBA LESSON 119 – INSTR function and MID function for strings




About this tutorial:

Video duration: 00:03:06
englishspacedog YouTube tutorial from Canada

How to use the INSTR function to find something in a string
and
How to use the MID function to get part of a string
plus
How to use the “&” ampersand to stick 2 strings together

here’s the code:
Private Sub lblENGLISHSPACEDOG_Click()

lblENGLISHSPACEDOG.Caption = _
Mid(lblENGLISHSPACEDOG.Caption, 1, InStr(lblENGLISHSPACEDOG.Caption, “CANADA”) – 1) _
& “TORONTO”

End Sub

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *