User Form Help

  • Thread starter Thread starter robertguy
  • Start date Start date
R

robertguy

Dave,

I've amended my code to :-

Me.TextBox1.Value = .Offset(myIndex, 1).Value & vbNewLine _
& .Offset(myIndex, 2) & vbNewLine & .Offset(myIndex, 3)


and


Me.TextBox1.Value = .Offset(myIndex, 1).Value & vblf _
& .Offset(myIndex, 2) & vblf & .Offset(myIndex, 3)

and changed :-

WordWrap = True
.MultiLine = True
.EnterKeyBehavior = True

But unfortunately it is still displaying the text on one line withou
inserting a new line !!

Any Ideas ?


Ro
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Form Help 1
date format problem?? 10
Code Crashing 3
Dynamic Offset from an Application.Goto cell = Date or Time 10
Error 381 8
excel formatting 2
Calculate Range 3
Smart way to concatenate into B1 all cells below until new info in Column A 1

Back
Top