Hi All,
Thanks for your help,
I'm new to vba but I tried to achieve most of the part but got struck with this approach.
I have dependent combobox1 to textbox4, each selection which i do from combobox1 will give different script on Textbox4.
So, I want Textbox1, Textbox2 & Textbox3 value which already displayed it's Value, so I want that value to add into this Textbox4 scripts.
Exam: Textbox1 --> one, Textbox2 --> two, Textbox3 --> three
Combobox1 list --> fruits, vegetables, location
Textbox4: fruits --> Apple is good for your health, I have %Textbox1%, I will get them %Textbox2%, Total will be %Textbox3%.
vegetables --> Vegetable buy %Textbox1% get %Textbox2%
location --> Will you visit this %Textbox3% places
So, Everytime I select anyone from combobox1 the script in Textbox4 will also change.. This Combobox1 & Textbox4 data is coming from Excel sheet where A column has Data for Combobox1 and B column has Data for Textbox4 from Sheet2.. And for other TextBox1,2,3 are getting data from column C, D & E from Sheet1.. Taking data from Sheet1 & Sheet2 and display then on sheet3 as a output with proper format which is already working..
I can able to pull excel data on to this Userform, This combobox1 & Textbox4 dependent also working good but I couldn't able to use proper logic on how to get this Textbox1,2,& 3 value inside of Textbox4 script..
And for this combobox & listbox together I have total upto 150 unique scripts and all those scripts will use TextBox1,2&3 for sure.
So I wanted to use all those 150 Scripts like below directly from excel sheet B column and add values from those Textbox1,2,3.
Apple is good for your health, I have %Textbox1%, I will get them %Textbox2%, Total will be %Textbox3%.
Vegetable buy %Textbox1% get %Textbox2%
Will you visit this %Textbox3% places
Note: Even Textbox1,2 & 3 will change data and they are unique.
Thanks