UserForm - How To Make TextBox Value Change Depending On ListBox Selection

Hi all,

I have a userform with a listbox (for the user to select a simple Yes or No), a textbox in which the user enters a number, and a second listbox that I would like to have change value.

For example, if ListBox21 = yes then TextBox13 = TextBox14 x 2
ElseIf
ListBox21 = No Then TextBox 13 = TextBox 14

I can't seem to get it right - the code I have so far for each item is as follows (I've taken out the bits that haven't worked for me)...

Please Login or Register  to view this content.

I don't know if it's just a syntax problem with my code or if I'm simply way off the mark - could someone point me in the right direction?

Cheers,

AJ

If I understand you correct try:

Please Login or Register  to view this content.

Thanks, Solus,

got a few type mismatch errors, so I changed a few things around, and still no luck. I've attached a dummy file for you to look at and the three boxes in question are the ones shaded in pink on the userform.

Cheers,

AJ

Is there a reason you're using a listbox instead of option buttons?

None at all, Solus (probably just force of habit) - I don't think I've ever used option buttons before; would it be easier that way?

Cheers,

AJ

Solus,

to answer my own question, yes, it's easier that way (so easy in fact that it's embarrassing, lol) - thanks for the nudge in the right direction.

CHeers,

AJ

No problem. Glad to help.

Have you found a proper solution or should we work on one for option buttons?

Solus,

I seem to have a solution that's working using option buttons, and I tested my userform last night to ensure that all data on the form was being written correctly to a worksheet, so I'm good for now. Thanks for the offer and for taking a look in the first place.

Cheers,

AJ