Siebel VB Language Reference > VB Language Reference >

LBound Function


This standard VB function returns the lower bound of the subscript range for an array.

Syntax

LBound(arrayname [, dimension] )

Argument
Description

arrayname

The name of the array to query

dimension

The dimension to query

Returns

The lower bound (lowest index number) of dimension dimension of arrayname.

Usage

The dimensions of an array are numbered starting with 1. If the dimension is not specified, 1 is the default.

LBound can be used with UBound to determine the length of an array.

Example

This example resizes an array if the user enters more data than can fit in the array. It uses LBound and UBound to determine the existing size of the array and ReDim to resize it. Option Base sets the default lower bound of the array to 1.

Option Base 1

Sub Button_Click
   Dim arrayvar() as Integer
   Dim count as Integer
   Dim answer as String
   Dim x, y as Integer
   Dim total
   total = 0
   x = 1
   count = 4
   ReDim arrayvar(count)
start:
   Do until x = count + 1
    arrayvar(x) = 98
    x = x + 1
   Loop
   x = LBound(arrayvar,1)
   count = UBound(arrayvar,1)
   For y = x to count
       total = total + arrayvar(y)
      Next y
End Sub

See Also

Dim Statement
Global Statement
Option Base Statement
ReDim Statement
Static Statement
UBound Function

Siebel VB Language Reference