Hi

This is my first time posting a query, but I truly am stuck on this one.

I am coding templated outlook emails from a userform.

I would like to type in a value in a textbox and then when I generate the email, I want a value from a different textbox dependent on the typed in value.

For example:
I have two Textbox's which say: 2-5 and 5-10. Next to these are another two textboxes which say £150 and £100 respectively.

I would like to have a 5th textbox that I can type a value in, say 3.5. This will then know that it falls in the 2-5 range and so when I generate the email it will input the textbox with £150 in to the template.

I hope I explained it clearly enough, but I'm not sure it is possible.

Any help would be greatly appreciated on this.

Thanks

Gareth