Compile Error on Chr(13)

S

scottfoxall

Hi there everone

I have a maco that populates a multiline TextBox, and here is a snip of code
that falls over:

UserForm2.TextBox4.Value = UserForm2.TextBox4.Value & Chr(13) & ppan

The error is pointed towards Chr(10), which is a Return (new line)

This macro works on some PCs but not on others?

All PCs use Excel 2000 with VBA Version 6.3

Anybody got any ideas?
 
B

Bob Phillips

try using vbNewline

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
S

scottfoxall

Thankyou Andrew

That did the trick. I had a CAD link in the script so these where tagged as
missing on PCs without CAD.
 
Top