|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
May 15th, 2003, 02:36 AM
|
|||
|
|||
line breaks in (auto)shapes
Hi,
my problem is the following, my code generates shapes (msoshape...) in excel on the fly. problem occurs when i insert the text into the shapes using shape.textframe.characters.text = str when I try to insert a line break VbCr I get a | in the field instead of a cr, using VbCrLf gives a line break but also inserts a | at the end of the previous line. since there is no multiline property to be set on a shape object i'm stuck .... any ideas ? Last edited by wiegels : May 15th, 2003 at 02:51 AM.
|
|
#3
June 26th, 2003, 01:46 PM
|
||||
|
||||
|
You have three constants
VbCr <-- carriage return VbLf <-- Line feed VbCrLf <-- carriage return & line feed Try using VbLf (which is just another way of saying Chr(10) ) 
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > line breaks in (auto)shapes |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
