Change Textbox value based on combo box value

Hello All,

I have a UserForm to generate personalized email responses. The email response on the Textbox1 will depend on the ComboBox1 value.

For instance, I have 2 languages in combo box. I have the responses on Sheet1 - Row 7 and Row 8.

Also I have textboxes that would contain names of Sender and Receiver. They will be part of the email responses.

Receiver will be combined with the column B7/B8 value and sender will be D7/D8 value.

Please show me how can I achieve this.

Thank you!

I changed the sample workbook. Sorry, I have to add a CheckBox.

Basically, what the checkbox1 would do is change the displayed value on the textbox. So, instead of displaying D7/D8 I would display E7 or E8.

I kinda did a code of my own on the initial request. I just dont know how I can incorporate the checkbox.

Another dilemma I have is when I generate the response first without any value on TextBox2 and Textbox3 and enter a value on the textbox2 and textbox3 the initially generated response does not update automatically.

Thanks again!

Quote from royUK

Will there also be a message to add?

hey royUK . Not sure what you mean by message here. Is it a MessageBox we're talking about?

basically, the objective of this file is generate email response based on cell values.

whatever it is on those cells, it would be the exact email message. I thought it would be easier to place those responses on cells.

That is actually correct royUK . As usual, I can't show here the exact file and its still in the works.

The "big one" will be place between columns B and C once we have that sorted out.

The sample I have here basically contains the greetings and closing only. I thought that would be enough to generate a code and we can just add that big one later on.

Okay, I see you.

That is one way of doing it. This is noted.

One thing though, I am not seeing the checkbox I added on the 2nd sample I attached here.

As I said, for example on "English", when that checkbox value is true then I want D7 on the generated response instead of C7.

Is that possible?

Quote from royUK

I didn't notice the second example

No worries, I kinda felt you haven't noticed it because I was too late to edit my initial post. Sorry for that.

So, what can we do on that 2nd example? hehe

I think so too. Your way was more efficient. I am just missing that checkbox and I am not sure how to incorporate that.

In the real worksheet, we use customize signatures depending on a language and/or country we are sending that email to. As there are countries that has standard for signatures, we have to customize them. That checkbox will be use for that.

Basically, I will add another column for a default signature and another column for a customize signature.

For instance, we are sending email in the UK. Instead of the default signature, we have to change it to the customize signature as it is that standard on that country. Though, the content of the email is the same which is the "English" row.

Yeah, sure. Though, I will only make up something, aight? Hahahaha

So, I added column E as the default signature and F as the customize signature.

On the textbox, they should be displayed after the column D value.

Also, while we are at it, and since we are using command button to generate the response, is there anyway we can add a MessageBox if the textboxes dedicated to Sender and Receiver are blank? Like a warning and would say, "Please enter name under Sender/Receiver" (depending on whichever is blank).

I had to change some things to fit what I need but this works perfectly royUK . Thank you so much again for your help! Awesome!