The Split is a good idea. But beware of cases where you don't have enough characters to split on. Good practice...
On Error Resume Next
element = Split(strInput,"_")(3)
if Err.Number = 9 then ' Subscript out of range
' there were not enough "_" in strInput
' element contains what you want
BTW, you can use the InStr format in a loop by searching for the string using the Start parameter of InStr. E.g.
j = 0
For i = 1 to 3
j = Instr(j+1,strInput,"_")
element = Mid(strInput,j+1)
But with the Split function, why bother? Besides, the loop doesn't include error handling.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group