View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Andrew Taylor Andrew Taylor is offline
external usenet poster
 
Posts: 225
Default 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?