Pass value and add line to multiline textbox

**fredpox** · 04-17-2010, 02:32 PM

Hi there,
I'm here to ask again for help since I can't find any solution on the Net coming for help..

The scenario is the following:
In a Userform I have a textbox in which the user enters the data.
Clicking a Command Button I want to pass the inserted data in a destination Multiline Textbox.

What I've done so far:
Setting up the Userform with the controls and try to write the following code.

Please Login or Register  to view this content.

Problem:
The values are always overwritten in the same line.

Any hint?

In attachment the dummy worksheet.

thanks in advance!
P.

**royUK** · 04-17-2010, 02:46 PM

To start with your code is in a non-existent button

Please Login or Register  to view this content.

**fredpox** · 04-18-2010, 05:12 AM

Hi RoyUK, and thanks for your support! :-)
The code works great, as usual your hints hit the spot!

ehm..I'm afraid I didn't understand your comment and the first 'empty' Sub..

Could you please help me to get the gist of it?

thanks again!
have a nice day
P.

**royUK** · 04-18-2010, 05:39 AM

I thought you had the code in the wrong button -inserttextbox,just ignore it because I've deleted the files now.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**fredpox** · 04-18-2010, 05:43 AM

It's Ok thanks again

bye
P.

**fredpox** · 04-18-2010, 06:02 AM

I forgot, I may need to insert also another kind of data: what the sub would look like if I add lines to the multiline textbox containing a counter which increments the data in the upper line by 1?
Say I insert a string with the sub you advised and I want to update another multiline textbox as well with a counter. The 1st line would be 1, the 2nd 2 and so on. How can I count the numbers already inserted in the multiline texbox (i.e. with just 1 line line1+1, if many lines lastline+1)

thanks again
P.