Visual Basic (VB and VBA)

Copyright 1999-2001 Christopher Greaves. All rights reserved. Home Page and email to [email protected]

If in doubt, record a macro and inspect the entrails!

Here is an INDEX to all the procedures.

You will probably need one copy of my GLOBAL DECLARATIONS.

Public Function boolStringInColumn(strArray() As String, lngColumn As Long, strCaption As String) As Boolean
' Procedure :   boolStringInColumn
' Description:  Test if the string is in the nominated column of the array.
' Copyright: Chris Greaves Inc.
' Inputs:       String array, column index, string.
' Returns:      TRUE if found.
' Assumes:      None.
' Side Effects: None.
' Tested:       By the calls shown below.
    boolStringInColumn = False
    Dim lngLimit As Long
    lngLimit = UBound(strArray, 2)
'Procs    Dim lngMaxLength As Long
    Dim lngIndex As Long
    For lngIndex = 1 To lngLimit
        If strArray(1, lngIndex) = strCaption Then
            boolStringInColumn = True
            Exit For
        Else
        End If
    Next lngIndex
End Function

We all knew nothing when we started …

Home Page and Contact Information Send email to [email protected]. This page was last updated Thursday, November 15, 2001

Visual Basic (VB and VBA)

Copyright 1999-2001 Christopher Greaves. All rights reserved. Home Page and email to [email protected]

If in doubt, record a macro and inspect the entrails!

Here is an INDEX to all the procedures.

You will probably need one copy of my GLOBAL DECLARATIONS.

Public Function boolStringInColumn(strArray() As String, lngColumn As Long, strCaption As String) As Boolean
' Procedure :   boolStringInColumn
' Description:  Test if the string is in the nominated column of the array.
' Copyright: Chris Greaves Inc.
' Inputs:       String array, column index, string.
' Returns:      TRUE if found.
' Assumes:      None.
' Side Effects: None.
' Tested:       By the calls shown below.
    boolStringInColumn = False
    Dim lngLimit As Long
    lngLimit = UBound(strArray, 2)
'Procs    Dim lngMaxLength As Long
    Dim lngIndex As Long
    For lngIndex = 1 To lngLimit
        If strArray(1, lngIndex) = strCaption Then
            boolStringInColumn = True
            Exit For
        Else
        End If
    Next lngIndex
End Function

We all knew nothing when we started …

Home Page and Contact Information Send email to [email protected]. This page was last updated Thursday, November 15, 2001