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