Thanks Nick thanks Patrick

Enjoy the party tonight

Cheers

Ren

"Patrick Molloy" wrote:

you can create a user defined function that "pades" the text with
spaces.....so add spaces to the left of the text to "right" justify and add
spaces eaually to the left and right to "center" the text.
As to how many letters show in the text box/lable is up to you. Remeber that
the width can be altered, but its easier to pre-define the width by setting
a fixed number of letters.

Patrick Molloy
Microsoft Excel MVP
"Ren" wrote in message
...
HAPPY NEW TO ALL!!

Simple question, is it possible vertically align text in a label or
textbox?

Thanks to all and may 2005 be the best ever.

CHEERS!!

Ren