Userform - Auto populate text box based on another box value

Hi There,

I was wondering whether it was possible to auto populate a text box based on the value of another textbox. I've created a small table to use as the range on another worksheet. So for example, if I type "100A" in text box 1, text box 2 and text box 3 will automatically populate based on that result.

I've attached a a sample spreadsheet with a very basic userform to give you a clearer idea of what I'm trying to achieve.

I've tried the following code, but as you can see on the sample spreadsheet it's not working .

Please Login or Register  to view this content.

Thanks in advance.

hi,
try this and see if it helps you

Please Login or Register  to view this content.

glad I could help you!