# VBA - LBound Function

#### Excel VBA Online Training

101 Lectures 6 hours

#### AutoCAD VBA Programming - Beginner Course

41 Lectures 3 hours

#### AutoCAD to Excel - VBA Programming Hands-On!

26 Lectures 2 hours

The LBound Function returns the smallest subscript of the specified array. Hence, LBound of an array is ZERO.

## Syntax

```LBound(ArrayName[,dimension])
```

## Parameter Description

• ArrayName − A required parameter. This parameter corresponds to the name of the array.

• Dimension − An optional parameter. This takes an integer value that corresponds to the dimension of the array. If it is '1', then it returns the lower bound of the first dimension; if it is '2', then it returns the lower bound of the second dimension and so on.

### Example

```Private Sub Constant_demo_Click()
Dim arr(5) as Variant
arr(0) = "1"           'Number as String
arr(1) = "VBScript     'String
arr(2) = 100           'Number
arr(3) = 2.45          'Decimal Number
arr(4) = #10/07/2013#  'Date
arr(5) = #12.45 PM#    'Time
msgbox("The smallest Subscript value of  the given array is : " & LBound(arr))

' For MultiDimension Arrays :
Dim arr2(3,2) as Variant
msgbox("The smallest Subscript of the first dimension of arr2 is : " & LBound(arr2,1))
msgbox("The smallest Subscript of the Second dimension of arr2 is : " & LBound(arr2,2))
End Sub
```

When you execute the above function, it produces the following output.

```The smallest Subscript value of the given array is : 0
The smallest Subscript of the first dimension of arr2 is : 0
The smallest Subscript of the Second dimension of arr2 is : 0
```
vba_arrays.htm