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.