Compile Error on Chr(13)
 

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?

Compile Error on Chr(13)
 

try using vbNewline

--
HTH

Bob Phillips

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

"scottfoxall" wrote in message
...
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?

Compile Error on Chr(13)
 

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

scottfoxall wrote:
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?

Compile Error on Chr(13)
 

Thankyou Andrew

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



"Andrew Taylor" wrote:

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

scottfoxall wrote:
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?