select in a combobox based on textbox value

[kelly mort]

Hello,
I need another help today too. I have a textbox called txtCurrentUser on a userform.
The value in txtCurrentUser could be as:
M1Afighter
M2Bswimmer
M3Cdrummer
M4Dpainter
M5 crier(contains space)

So this is what i wanna do: when the 4th character in txtCurrentUser is say "f", then i wanna select the first item in a combobox called Cmb1. And when the 4th character in txtCurrentUser is say "s", then i wanna select the second item in the Cmb1. This can go down to say 12 conditions. I need guidance with how to achieve my goal.

Thanks in advance.
Kelly

 

[kelly mort]

Yessss!!! Thanks very much. Work done.
Kelly

 

[MickG]

You're welcome