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