ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Aligning text in a text frame (https://www.excelbanter.com/excel-programming/298816-aligning-text-text-frame.html)

KDUT

Aligning text in a text frame
 
Hi,

I need the vba code that will center align some text in a
text box for me - at the minute I have :

with oPPTShape
.TextFrame.HorizontalAlignment =xlHAlignCenter

And it doesn't work - any ideas please?

Many thanks
KDUT

Juan Pablo González

Aligning text in a text frame
 
Using either

..TextFrame.HorizontalAlignment = xlHAlignCenter

or

..TextFrame.HorizontalAlignment = xlCenter

worked for me. But I'm curious about where do you have this code ? (just
because of the name of that variable, I would assume it's in or from
PowerPoint ?)

--
Regards

Juan Pablo González

"KDUT" wrote in message
...
Hi,

I need the vba code that will center align some text in a
text box for me - at the minute I have :

with oPPTShape
.TextFrame.HorizontalAlignment =xlHAlignCenter

And it doesn't work - any ideas please?

Many thanks
KDUT





All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com