InStr Function

αžαŸ’αžšαž‘αž”αŸ‹β€‹αž‘αžΈαžαžΆαŸ†αž„β€‹αžšαž”αžŸαŸ‹β€‹αžαŸ’αžŸαŸ‚αž’αž€αŸ’αžŸαžšβ€‹αž˜αž½αž™β€‹αž€αŸ’αž“αž»αž„β€‹αžαŸ’αžŸαŸ‚αž’αž€αŸ’αžŸαžšβ€‹αž˜αž½αž™β€‹αž‘αŸ€αžΒ αŸ”

αž”αžΎαž€β€‹αž―αž€αžŸαžΆαžšβ€‹αž“αŸαŸ‡β€‹αž€αŸ’αž“αž»αž„β€‹αžšαž”αŸ€αž”β€‹αž”αžΆαž“β€‹αžαŸ‚β€‹αž’αžΆαž“

αžœαžΆαž€αŸ’αž™β€‹αžŸαž˜αŸ’αž–αž“αŸ’αž’ αŸ–


InStr ([Start As Long,] Text1 As String, Text2 As String[, Compare])

αžαž˜αŸ’αž›αŸƒβ€‹αžαŸ’αžšαž‘αž”αŸ‹ αŸ–

Integer

αž”αŸ‰αžΆαžšαŸ‰αžΆαž˜αŸ‰αŸ‚αžαŸ’αžš αŸ–

Start: A numeric expression that marks the position in a string where the search for the specified substring starts. If you omit this parameter, the search starts at the first character of the string. The minimum allowed value is 1. The maximum allowed value is 2,147,483,648.

αž–αŸαž›β€‹αž…αž»αŸ‡β€‹αž αžαŸ’αžαž›αŸαžαžΆβ€‹

αž–αŸαž›β€‹αž”αž„αŸ’αž€αžΎαžβ€‹αž―αž€αžŸαžΆαžšβ€‹ PDF

αž”αŸ’αžšαŸ€αž”αž’αŸ€αž”Β αŸ– αž€αž“αŸ’αžŸαŸ„αž˜β€‹αž›αŸαžβ€‹αžŸαŸ’αžšαŸαž…αž…αž·αžαŸ’αžβ€‹ αžŠαŸ‚αž›β€‹αž€αŸ†αžŽαžαŸ‹β€‹αž”αŸ’αžšαž—αŸαž‘β€‹αž“αŸƒβ€‹αž€αžΆαžšβ€‹αž”αŸ’αžšαŸ€αž”αž’αŸ€αž”Β αŸ” αžαž˜αŸ’αž›αŸƒβ€‹αžšαž”αžŸαŸ‹β€‹αž”αŸ‰αžΆαžšαŸ‰αžΆαž˜αŸ‰αŸ‚αžαŸ’αžšβ€‹αž’αžΆαž…β€‹αž‡αžΆ ០ ឬ αŸ‘Β αŸ” αžαž˜αŸ’αž›αŸƒβ€‹αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜β€‹αž‚αžΊ ៑ αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αž€αžΆαžšβ€‹αž”αŸ’αžšαŸ€αž”αž’αŸ€αž”β€‹αž’αžαŸ’αžαž”αž‘β€‹αžŠαŸ‚αž›β€‹αž˜αž·αž“β€‹αž”αŸ’αžšαž€αžΆαž“αŸ‹β€‹αž’αž€αŸ’αžŸαžšβ€‹αžαžΌαž…αž’αŸ†Β αŸ” αžαž˜αŸ’αž›αŸƒ ០ αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αž€αžΆαžšβ€‹αž”αŸ’αžšαŸ€αž”αž’αŸ€αž”β€‹αž‚αŸ„αž›αž–αžΈαžšβ€‹αžŠαŸ‚αž›β€‹αž”αŸ’αžšαž€αžΆαž“αŸ‹β€‹αž’αž€αŸ’αžŸαžšαžαžΌαž…αž’αŸ†Β αŸ”

To avoid a run-time error, do not set the Compare parameter if the first optional parameter is omitted.

Error codes:

5 αž€αžΆαžšβ€‹αž αŸ…β€‹αž”αŸ‚αž”αž”αž‘β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ

αž§αž‘αžΆαž αžšαžŽαŸ αŸ–


Sub ExamplePosition
Dim sInput As String
Dim iPos As Integer
    sInput = "Office"
    iPos = Instr(sInput,"c")
    Print iPos
End Sub

Please support us!