dwarek

Board Regular
Joined
Jul 15, 2016
Messages
77
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

gallen

Well-known Member
Joined
Jun 27, 2011
Messages
2,006
You need to set he 'MultiLine' property to true. It is false by default.

This can be done at design time
 

Watch MrExcel Video

Forum statistics

Threads
1,129,373
Messages
5,635,884
Members
416,886
Latest member
coreyalaurence37

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top