Split string when specific word is found

[DB4284]

I want to extract a value from a string eg

teststring - teststring2 [01022] teststring3 [082382] keyword [1234]

I want to be able to find the "keyword" value in the string and then extract the value "1234" from the string. I have been looking at various functions and im thinking that a split function is required.

[pbaldy]

You could use the Split() function. You'd step through the resulting array until you found the keyword, then grab the next value.

If you wanted a non-VBA solution, you could also use a combination of InStr() to find the position of the keyword, another to find the position of the first "[" after that, another to find the position of the "]" after it, and the Mid() function using those two values.