text box in user form

[Steve001]

Hi

Is it possible to insert a text string in a certain position each and every time ?

I have a text box that has 13 lines

ie

string 1 - always goes on line 1
string 2 - always goes on line 2
string 3 - always goes on line 3

etc

not got a clue if someone can help

PS please put comments in the code still a noob

Thanks

Steve

 

[Nine Zero]

Hello

After each string you need vbNewLine appended to the end of the line for example

TextBox1.Value = String1 & vbNewLine & String2 & vbNewLine & String3........and so on

give it a try

 

[Steve001]

Hi Nine Zero

Thanks didn't know you could do that approach

Thought you had to move the cursor then print on that line.

Will give it a go

Steve

 

[Steve001]

hi

That approach not working unless I am doing something wrong - they are all on the same line and I have word like "paragraph" markings in my message box at the end of each sring?

Steve

 

[Nine Zero]

Ahh yes i forgot to mention you must set the textbox to allow multiple lines so you need to add this line of code before the one i posted earlier

TextBox1.MultiLine = True

That should fix it

 

[Steve001]

Working now

Thank you

Steve