Compile Error on Chr(13)

[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?

[Bob Phillips]

try using vbNewline

--
HTH

Bob Phillips

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

"scottfoxall" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[Andrew Taylor]

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?

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



"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?
>
>