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.
 
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!
 

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
Creating VBA Functions When Creating Spreadsheet Via VBA? 6
Form Textbox Mulitline question 3
vbCrLf problem vs Excel 2
Argument Not Optional - Unable To Find Specific Case Like This 0
Square before beginning of a new line 3
Clipboard macro seriously locks up (or whatever it does) myclipboard! [XL2003] 1

Back
Top