Compile Error on Chr(13)

[Guest]

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?

 

[Bob Phillips]

try using vbNewline

--
HTH

Bob Phillips

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

 

[Andrew Taylor]

Possibly a missing reference - check Tools/References in VBA.

 

[Guest]

Thankyou Andrew

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