Function Statement

āĻāĻ•āĻŸāĻŋ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻŸāĻžāĻ‡āĻĒ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖ āĻ•āĻ°āĻžāĻ° āĻœāĻ¨ā§āĻ¯ āĻāĻ•āĻŸāĻŋ āĻāĻ•ā§āĻ¸āĻĒā§āĻ°ā§‡āĻļāĻ¨ āĻšāĻŋāĻ¸ā§‡āĻŦā§‡ āĻŦā§āĻ¯āĻŦāĻšā§ƒāĻ¤ āĻ¸āĻžāĻŦāĻ°ā§āĻŸāĻŋāĻ¨ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖ āĻ•āĻ°āĻž āĻšā§ŸāĨ¤

āĻ¸āĻŋāĻ¨āĻŸā§āĻ¯āĻžāĻ•ā§āĻ¸

āĻĒā§āĻ¯āĻžāĻ°āĻžāĻŽāĻŋāĻŸāĻžāĻ° āĻĻā§‡āĻ–ā§āĻ¨

āĻĒā§āĻ¯āĻžāĻ°āĻžāĻŽāĻŋāĻŸāĻžāĻ°:

āĻ¸āĻŋāĻ¨āĻŸā§āĻ¯āĻžāĻ•ā§āĻ¸

Function Name[(VarName1 [As Type][, VarName2 [As Type][,...]]]) [As Type]

āĻ¸ā§āĻŸā§‡āĻŸāĻŽā§‡āĻ¨ā§āĻŸ āĻŦā§āĻ˛āĻ•

[Exit Function]

āĻ¸ā§āĻŸā§‡āĻŸāĻŽā§‡āĻ¨ā§āĻŸ āĻŦā§āĻ˛āĻ•

End Function

āĻĒā§āĻ¯āĻžāĻ°āĻžāĻŽāĻŋāĻŸāĻžāĻ°

āĻ¨āĻžāĻŽ: āĻĢāĻžāĻ‚āĻļāĻ¨ āĻĻā§āĻŦāĻžāĻ°āĻž āĻĒā§āĻ°āĻĻāĻžāĻ¨āĻ•ā§ƒāĻ¤ āĻŽāĻžāĻ¨ āĻ§āĻžāĻ°āĻŖ āĻ•āĻ°āĻžāĻ° āĻœāĻ¨ā§āĻ¯ āĻ¸āĻžāĻŦāĻ°ā§āĻŸāĻŋāĻ¨ā§‡āĻ° āĻ¨āĻžāĻŽāĨ¤

āĻ¸āĻžāĻŦāĻ°ā§āĻŸāĻŋāĻ¨ā§‡ āĻĒā§āĻ°ā§‡āĻ°āĻŋāĻ¤ āĻšāĻŦā§‡ āĻāĻŽāĻ¨ VarName: āĻĒā§āĻ¯āĻžāĻ°āĻžāĻŽāĻŋāĻŸāĻžāĻ°āĨ¤

āĻŸāĻžāĻ‡āĻĒ: āĻŸāĻžāĻ‡āĻĒ-āĻĄāĻŋāĻ•ā§āĻ˛ā§‡ā§ŸāĻžāĻ°ā§‡āĻļāĻ¨ āĻ•ā§€āĻ“ā§ŸāĻžāĻ°ā§āĻĄāĨ¤

āĻ‰āĻĻāĻžāĻšāĻ°āĻŖ:


Sub ExampleExit
Dim sReturn As String
Dim sListArray(10) As String
Dim siStep As Single
    For siStep = 0 to 10 REM Fill array with test data
        sListArray(siStep) = chr$(siStep + 65)
        MsgBox sListArray(siStep)
    Next siStep
    sReturn = LinSearch(sListArray(), "B")
    Print sReturn
End Sub
 
Function LinSearch( sList(), sItem As String ) As Integer
Dim iCount As Integer
REM Linsearch searches a TextArray:sList() for a TextEntry:
REM āĻāĻ° āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻ•āĻ°āĻž āĻŽāĻžāĻ¨ āĻšāĻ˛ā§‹ āĻ­ā§āĻ•ā§āĻ¤āĻŋāĻ° āĻ‡āĻ¨āĻĄā§‡āĻ•ā§āĻ¸ āĻ…āĻĨāĻŦāĻž ā§Ļ (āĻ¨āĻžāĻ˛)
    For iCount=1 To Ubound( sList() )
        If sList( iCount ) = sItem Then
            Exit for REM sItem found
        End If
    Next iCount
    If iCount = Ubound( sList() ) Then iCount = 0
    LinSearch = iCount
End Function

Please support us!