Since it's confusing for you, only check below approach code then I'll ask for other in case If i couldn't able to find out. Ignore above what I wrote so far. since I couldn't able to explain better.. I need your help for below one only for now please.
For below I have userform with 4 textboxs, 1 combobox & textbox dependent, one save button. I enter text in those 4 textbox's manually like customer name, amount, phone & email id.
|Mobile Recharge||Customer Name <Customer name> wanted to pay amount : <Amount> need to recharge for mobile number:<mobile number> and optional email id is: <email ID >|
|Consult Doctor||Need to take appointment, Patient Name: <Customer Name> can reach him/her on phone number:<phone code> and email id:<email ID>|
|loan Pending amount||Dear customer: <customer name>, you having pending amount of <amount> which is registered on your mobile number:<phone number> further details you will get from bank.|
So, I have category & sub-category.. Category I kept in combobox & sub-category in Textbox. They're few other textbox which has customer name, amount, phone & email id. This category & sub-category both are for example I kept in Sheet2 in A & B column since they're many more than 100 and pulling directly into userform.
Example: category is "Mobile recharge" sub-category is "Customer Name <Customer name> wanted to pay amount : <Amount> need to recharge for mobile number:<mobile number> and optional email id is: <email ID >". there are different script like this as shown in above table format.
I want to display other Textbox's (Customer name, amount, phone & email id) into this sub-category script.. how to do it..?
I need your code only to modify sub-category script with other textbox's is all I wanted.. On sub-category textbox I want to add other textbox's values like below:
Customer Name(Textbox1) --> Jhon
Amount(Textbox2) --> 150
Phone(Textbox3) --> 123456789
Email ID(Textbox4)--> [email protected]
I want to see in sub-category textbox modified like below before I save to sheet.
"Customer Name <Jhon> wanted to pay amount : <150> need to recharge for mobile number:<123456789> and optional email id is: <[email protected]>"
If I select another category & sub-category then also values of other textbox's need to modify accordingly with sub-category.
I need code for above approach for now..