How to update userform textbox based on listbox selection?

[knykil]

Hi All,

I have a macro that allows the user to move any data row to another tab. When the user opens the userform, several data fields that make up that row are auto-populated. However, when a new sheet is selected from the ListBox, three of the inputs (textboxes) need to be changed. I'm hoping to do this automatically based on their selection.

I've tried running an something like: IF ListBox1 = "P MFI" THEN TextBox1 = "Portfolio" END IF. This does not seem to work though..

Any thoughts?

Thanks!

[torachan]

lot easier to work with a workbook than a vague description.
see big yellow banner - how to upload a de-sensitised workbook.
torachan.

[knykil]

lot easier to work with a workbook than a vague description.
see big yellow banner - how to upload a de-sensitised workbook.
torachan.

Hi Torachan,

Still getting use to the forum etiquette. My apologies. I've attached the example workbook.

When looking at the forms section, I'm referring to "Move_Case".

After auto-populating TextBox 1, 2 and 3, with the existing values, I would like them to update immediately in the userform when the user selects the New Group Location in the ListBox1.

For example:

Original Values:
Line of Business = Medical
Segment = Portfolio
Funding = FI (fully-insured)

When the user selects 'L DASO', the values would automatically update to:
Line of Business = Dental
Segment = Large
Funding = ASO