| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why would 1 excel PC understand chr(13) and anoughter wouldn't?
I have created a textbox within a Userform within excel.
Within the code I used the code for a carriage return "chr(13)". My PC likes this code and everything runs fine, but other PC's do not understand it and refuse to run the code? Why? We are all using the same OS and the same version of Excel? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why would 1 excel PC understand chr(13) and anoughter wouldn't?
On Nov 22, 1:57 pm, thefirstcybot
wrote: I have created a textbox within a Userform within excel. Within the code I used the code for a carriage return "chr(13)". My PC likes this code and everything runs fine, but other PC's do not understand it and refuse to run the code? Why? We are all using the same OS and the same version of Excel? Seems a bit strange ... try using vbCrLf instead of chr(13) and see if that works. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why would 1 excel PC understand chr(13) and anoughter wouldn't?
Are you using the code from the same workbook or merely identical copies of
the same code. If the latter, my guess is the textbox's MultiLine property is true in one wb & false in the other, and/or similar with WordWrap. Regards, Peter T "thefirstcybot" wrote in message ... I have created a textbox within a Userform within excel. Within the code I used the code for a carriage return "chr(13)". My PC likes this code and everything runs fine, but other PC's do not understand it and refuse to run the code? Why? We are all using the same OS and the same version of Excel? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why would 1 excel PC understand chr(13) and anoughter wouldn't?
It possibly is not the Chr(13) at all. One thing to check on the machines
that have the problem is look for missing refernces. In the VBE select Tools|Refernces and look for anything that starts with Missing: -- HTH... Jim Thomlinson "thefirstcybot" wrote: I have created a textbox within a Userform within excel. Within the code I used the code for a carriage return "chr(13)". My PC likes this code and everything runs fine, but other PC's do not understand it and refuse to run the code? Why? We are all using the same OS and the same version of Excel? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why would 1 excel PC understand chr(13) and anoughter wouldn't?
99% sure that this is caused by a missing reference as explained by Jim T.
RBS "thefirstcybot" wrote in message ... I have created a textbox within a Userform within excel. Within the code I used the code for a carriage return "chr(13)". My PC likes this code and everything runs fine, but other PC's do not understand it and refuse to run the code? Why? We are all using the same OS and the same version of Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesn't Excel understand what 'Manual' for Calculations? | Excel Discussion (Misc queries) | |||
| Does Excel understand Latitude and Longitude (GPS) co-ordinates? | Excel Discussion (Misc queries) | |||
| Making Excel understand the diffrence in capitialization? | Excel Programming | |||
| How many workbooks and worksheets can Excel understand? | Excel Discussion (Misc queries) | |||
| I don't Understand | Excel Worksheet Functions | |||
Linear Mode
