Chr(13) in a text box for excel 1

[AGlazer]

Hey, guys.

This is a basic question, but I can't seem to figure it out. I have a script that adds a textbox to a graph. The data in the textbox should look like this:

Joe Shmoe
- a
- b
- c

For some reason, when I'm creating the string (even using either Chr(13) & Chr(10) & Chr(13) or & vbCrLf) it puts them all on the same line with the "unknown character" square between them.

Any ideas?

 

[DaleWatson123321]

I just ran the following and it worked...

Sub Modify_TextBox()
ActiveChart.Shapes("Text Box 1&quot.Select
Selection.Characters.Text = "Joe Schmoe" & Chr(10) & " - 1" & Chr(10) & " - 2" & Chr(10) & " - 3"
Selection.AutoScaleFont = True
End Sub

Hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[SkipVought]

Hi,
MultiLine & WordWrap have to be set to True.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

You can use vbCrLf instead of Chr(10) & Chr(13)



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com