Hi guys i have created a userform the program is running successfully but the issue is in one text box sometimes i need to enter lot of data like points for example
1) Is the request to ADD or UPDATE an SSI? - ADD
2) Is there a valid Acronym / Access code on account - Yes
3) Is there a valid Citi filter group / Broker Acronym on account? - Yes
4) Is the required SSI part of Citi Filter Group - Yes
5) Is the required SSI In Alert? - Yes
6) Does the SSI have a status of deleted? - No
7) Is the SSI cancelled? - No
8) Was the SSI added to Alert the same or the previous business day as the BPM was raised? - No
9) Is the required SSI in complete queue? - Yes
10) Does it appear more than once with the first instance containing an Auto ID and rest with user ID? - No
11) Does it have a user ID? - No
12) Does it have a Auto ID? - Yes
so i just copy this from my word and paste it to textbox but it just print the first line alone in the excel file, i want entire data to be pasted into the excel via textbox
is there any solution for it pls help me out
1) Is the request to ADD or UPDATE an SSI? - ADD
2) Is there a valid Acronym / Access code on account - Yes
3) Is there a valid Citi filter group / Broker Acronym on account? - Yes
4) Is the required SSI part of Citi Filter Group - Yes
5) Is the required SSI In Alert? - Yes
6) Does the SSI have a status of deleted? - No
7) Is the SSI cancelled? - No
8) Was the SSI added to Alert the same or the previous business day as the BPM was raised? - No
9) Is the required SSI in complete queue? - Yes
10) Does it appear more than once with the first instance containing an Auto ID and rest with user ID? - No
11) Does it have a user ID? - No
12) Does it have a Auto ID? - Yes
so i just copy this from my word and paste it to textbox but it just print the first line alone in the excel file, i want entire data to be pasted into the excel via textbox
is there any solution for it pls help me out