Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default VBA - Chr(13)

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default VBA - Chr(13)

In what sense, how are you using it ?

NickHK

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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default VBA - Chr(13)

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!


"NickHK" wrote:

In what sense, how are you using it ?

NickHK

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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default VBA - Chr(13)

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


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


"NickHK" wrote:

In what sense, how are you using it ?

NickHK

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






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default VBA - Chr(13)

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)

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"