Remove small square caused by vbCrLf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I connected some textboxes on my form and using vbCrLf to create a new line
between them. After I insert the whole string into a cell the small sqares
appeared which is not what I want. Could you tell me how to remove them and
remain the format?

Clara
 
I would copy one of the square boxes. Then go into the Edit Menu- Replace.
Paste the square box in the from box and put nothing in the to. then replace
all.
 
use only VbLf rather than vbCrLf

make sure the cell is formatted for word wrap.
 
Tom,
I have a small square that appear in a column of formula cell (a formula
that is combining text from a number of other cells). I don't know what VvLf
and vbCrLf refer to so I can't use your advice. Can you explain it to me?
The cells are formatted for word wrap. I am using 2003. Thanks so much!
 
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

litter square caused by ALT + Enter 1
square boxes when using vbcrlf 5
Line breaks appear as squares in comments 1
Form Textbox Mulitline question 3
Creating VBA Functions When Creating Spreadsheet Via VBA? 6
vbCrLf problem vs Excel 2
Square before beginning of a new line 3
Argument Not Optional - Unable To Find Specific Case Like This 0

Back
Top