Vertical Alignment

[Guest]

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

 

[Nick Hodge]

Ren

In short - No

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Patrick Molloy]

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

 

[Guest]

Thanks Nick thanks Patrick

Enjoy the party tonight

Cheers

Ren