UserForm; Textbox; Multiline; NonPrintable Characters

S

sa3214

I've created a userform in Excel 97 with a text box
The properties of the text box include:
Multiline = True
Wordwrap = True

When entering data in the text box I press Ctrl & Enter to start a new line

When the data is transferred to the spreadsheet it includes non-printable
characters, denoted by small square boxes.

I can manually delete these characters but would like to find a more elegant
way of doing so

Can you suggest some code that I could use

Regards & TIA

Jim Burton
 
P

papou

Hello
Worksheets("Sheet1").range("A1").Value = Application.Substitute(TextBox1,
Chr$(13&),"")
HTH
Cordially
Pascal
 
S

sa3214

I've found that Ctrl & Enter is inserting Chr(10) and Chr(13) into the text
string
I have used the following code to edit the cell after transferring the
string.

.Cells(EntryRow, 9).Replace What:=Chr(13), Replacement:=""

It works ... but is there a better way of creating new lines in a textbox
and hence in the cell
 

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

Replacing Non Printable Characters 2
Copying multiline textboxes from userform to worksheet cell 1
WordWrap in TextBox on a UserForm 2
display special characters in some textbox fields to ensure data f 1
Userform Textbox multiline Vs format in worksheet 4
Excel Adding Text to a Textbox in Excell 1
transferring multiline text from userform to worksheet - line break problem 6
TextBox with Fixed Width and Autosized Height 4

Top