VBA - Chr(13)

G

Guest

Does anybody know why the carriage RTN Chr(13) works on some PCs but is
throws out a compile error on other PCs. All the PCs use XL2000 with VBA 6.3
 
B

Bob Phillips

Don't start multiple threads in multiple groups where the information is
dispersed. You do not deserve help with an approach like that.

--
HTH

Bob Phillips

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

Guest

As I said, I am not a developer!

I use this Chr(10) or Chr(13) when I write to text files for Carriage RTN

I tried it when populating a TextBox with a collection of values from a
number of cells. For example the textbox might be populated:

Andy
Paul
Nick
Sarah

I don't understand why this works fine on some desktops but not on other?

Sorry Bob, I thought this was a discussion gruop set up for sharing
knowledge and helping those you could do with some help!
 
P

Peter T

Sorry Bob, I thought this was a discussion gruop set up for sharing
knowledge and helping those you could do with some help!

Indeed a discussion group should be for sharing knowledge. But you had
earlier posted essentially the same question in .misc where you also got a
different set of answers, so readers of this group cannot 'share' that
information. In particular you have not informed this group that your
problem was due to a missing reference.

If someone responds your question in one group, then sees the same question
in another it gives the impression you don't care how many people
unnecessarily go to the trouble of duplicating answers to your question, and
also don't care if readers of one group don't get the benefit of the
ultimate solution visible only in the other group. It can lead to
antagonism.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Chr$ 3
remove crlf 1
Compile Error on Chr(13) 3
Compile error [Chr(13)] 3
SQL VBA Excel 0
Retrieving Data from SQL Server to Excel 1
a better way to query? 2

Top