Similar to VBInstr, but this one does it in reverse, which is instrrev() function, but again, clearer to use since I am stupid and never could use it the first time correct.
The same way we did VBInstr.
Important note, StartSearch is negative as initial value, when you want to use you need to pass +ve numbers not -ve, and the number will be the location of the character you want to start searching from.
Function VBInstrRev(SearchFor, SearchIn, Optional StartSearch = -1, Optional SearchCompare = vbTextCompare)
VBInstrRev = InStrRev(SearchIn, SearchFor, StartSearch, SearchCompare)
End Function
Function VBInstr_Rev(SearchFor, SearchIn, Optional StartSearch = -1, Optional SearchCompare = vbTextCompare)
VBInstr_Rev = InStrRev(SearchIn, SearchFor, StartSearch, SearchCompare)
End Function
VBInstrRev = InStrRev(SearchIn, SearchFor, StartSearch, SearchCompare)
End Function
Function VBInstr_Rev(SearchFor, SearchIn, Optional StartSearch = -1, Optional SearchCompare = vbTextCompare)
VBInstr_Rev = InStrRev(SearchIn, SearchFor, StartSearch, SearchCompare)
End Function
SearchFor, SearchIn, Optional StartSearch = -1, Optional SearchCompare = vbTextCompare
Views 207
Downloads 82
CodeID
DB ID
ANmarAmdeen
614
Revisions
v2.0
Friday
January
26
2024