Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compile Error on Chr(13)
try using vbNewline
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "scottfoxall" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compile Error on Chr(13)
Thankyou Andrew
That did the trick. I had a CAD link in the script so these where tagged as missing on PCs without CAD. "Andrew Taylor" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically compile totals from 12 worksheets into 1? | Excel Worksheet Functions | |||
compile error in hidden module: autoexecnew - how do I get rid? | Charts and Charting in Excel | |||
Compile error in hidden module | Excel Discussion (Misc queries) | |||
Compile Errors with Different versions of Excel | Excel Discussion (Misc queries) |