Mid VBA function – How to extract text part

Last Updated on January 11, 2023 by token

1. MID VBA function – Description

The MID VBA function is equivalent to the SUBSTRING or SUBSTR function in other programming languages. How does the MID function work? The VBA MID function cuts text from other text. For example, from the sentence “I’m learning to program in VBA, we can cut out the word” programming “. How to do it? The syntax of the function and its example of use are presented below. The function can be compared to the FRAGMENT.TEXT from an Excel spreadsheet.

2. MID function – Syntax

The syntax for the Mid function is as follows:

MID (String, Start [, Length])

String – A text string from which to cut the text.

Start  – The next position in the text string from which to start cutting the text. The argument is of the Long data type.

Length – Optional argument. We can define in it how many characters from the string we want to cut. If no argument is used, the return is the entire string starting at the position in Start.

Function return : String / text value

3. VBA Mid function – Example

How to use MID function in VBA Excel? Below is an example of using the MID function in the VisualBasic Editor.

Example 1:  An example of using the Mid VBA function – result in the MsgBox window and a sheet cell.

Sub MidFunctionExample ()

MsgBox Mid ("Learning VBA Functions", 10)
MsgBox Mid ("Learning VBA functions", 10, 7)
Range ("A1") = Mid ("Learning VBA", 10, 7)
MsgBox Mid (Range ("A1"), 1, 7)

End Sub
Excel VBA functions - MID VBA function
Excel VBA functions – MID VBA function

4. VB Abs function – Additional information

  • none

5. Abs VisualBasic function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365.

The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address:  VBA functions.

Leave a comment

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

%d bloggers like this: