Inconsistant formatting of Userform Textbox and Spreadsheet storage format

J

Jim May

In an application (in progress) one of my Userform controls (a textbox)
for Comments --
I have property setting as follows:
EnterKeyBehavior = True
Multiline = True
ScrollBar = 2 (Vertical only)
Height = 35
Width = 366
Word Wrap = False

In one of my spreadsheets where this info is stored I have the code:
(where Col P is my Comments Text)

Private Sub Worksheet_Activate()
Columns("P:p").WrapText = True
Columns("P:p").Columns.AutoFit
Columns("P:p").ColumnWidth = 55
Range("A1").CurrentRegion.Rows.AutoFit
End Sub

My Col P looks hideous (see below)
"sadfsadfsdf << each of these lines has the sqbox linefeed character
following
sadfsadf
sadfsdf
sdf
sdkflsakf
a;sdlkjf;alskfd
"

What should I change to bring this more into harmony?
Any pointers appreciated.
 

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

Top