| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vertical Alignment
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vertical Alignment
Ren
In short - No -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vertical Alignment
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vertical Alignment
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Vertical Cell Alignment | Setting up and Configuration of Excel | |||
| Vertical alignment does not work | New Users to Excel | |||
| In Cell alignment, how do I update the default vertical alignment | Setting up and Configuration of Excel | |||
| Vertical alignment in data table? | Charts and Charting in Excel | |||
| Top alignment with vertical text? | Excel Discussion (Misc queries) | |||
Linear Mode
