Working with textboxes in VBA

[wpryan]

Hi All,

I am stumbling through working with textboxes in VBA. I found code that will generate the text box, and how to put it in the location I am looking for, but how to format the text? This is where I'm coming up short... The short bit of code I have is:

myDocument.Shapes.AddTextbox(msoTextOrientationHorizontal, _    100, 100, 200, 50) _    .TextFrame.Characters.Text = "Test Box"

I would like to center the text in the text box (center and middle alignment). How to do so...?

Thanks in advance...

 

[dmt32]

Thanks again! I'm just starting to dabble with objects, it's entirely a different beast!

most welcome - always worth reading up in the VBA helpfile.

Dave