| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on aligning a cell itself, not the text | Excel Discussion (Misc queries) | |||
| aligning text | Excel Worksheet Functions | |||
| Aligning text in a text box | Excel Discussion (Misc queries) | |||
| Aligning text | Excel Discussion (Misc queries) | |||
| aligning entry in text box | Excel Programming | |||
Linear Mode
