Align text for labels in user forms

I have recently been starting to create user forms but
have become frustrated by what I'm sure is a very minor
thing. When I make a label to indicate what a text box
is used for, the text within the label is always justifed
top left. I have found how to change the horizontal
justification with TextAlign in Properties but I can't
find a way of centring the text vertically. Because the
controls all fit into the grid, all my labels do not
align with the controls that they are associated with.

Question: how do I centre the text vertically? Or can I
turn off the grid?

Many thanks for any help,

Tim

Hi Tim,

You can't align the text in a Label control vertically. You can,
however, turn off the grid. From the VBE menu choose Tools/Options/General.
Unchecking the "Align Controls to Grid" checkbox will allow you to move
controls independent of the grid. Unchecking the "Show Grid" checkbox will
hide the grid itself (these two settings are independent).

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* Unsolicited e-mail replies will be ignored *


"Tim Archer" <[email protected]> wrote in message
news:[email protected]...
>I have recently been starting to create user forms but
> have become frustrated by what I'm sure is a very minor
> thing. When I make a label to indicate what a text box
> is used for, the text within the label is always justifed
> top left. I have found how to change the horizontal
> justification with TextAlign in Properties but I can't
> find a way of centring the text vertically. Because the
> controls all fit into the grid, all my labels do not
> align with the controls that they are associated with.
>
> Question: how do I centre the text vertically? Or can I
> turn off the grid?
>
> Many thanks for any help,
>
> Tim

Tim,

You might also want to take a look at Stephen Bullen's VBE Tools add-in,
which allows you to 'nudge controls

http://www.oaltd.co.uk/VBETools/Default.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob Bovey" <[email protected]> wrote in message
news:[email protected]...
> Hi Tim,
>
> You can't align the text in a Label control vertically. You can,
> however, turn off the grid. From the VBE menu choose
Tools/Options/General.
> Unchecking the "Align Controls to Grid" checkbox will allow you to move
> controls independent of the grid. Unchecking the "Show Grid" checkbox will
> hide the grid itself (these two settings are independent).
>
> --
> Rob Bovey, Excel MVP
> Application Professionals
> http://www.appspro.com/
>
> * Please post all replies to this newsgroup *
> * Unsolicited e-mail replies will be ignored *
>
>
> "Tim Archer" <[email protected]> wrote in message
> news:[email protected]...
> >I have recently been starting to create user forms but
> > have become frustrated by what I'm sure is a very minor
> > thing. When I make a label to indicate what a text box
> > is used for, the text within the label is always justifed
> > top left. I have found how to change the horizontal
> > justification with TextAlign in Properties but I can't
> > find a way of centring the text vertically. Because the
> > controls all fit into the grid, all my labels do not
> > align with the controls that they are associated with.
> >
> > Question: how do I centre the text vertically? Or can I
> > turn off the grid?
> >
> > Many thanks for any help,
> >
> > Tim
>
>

Fantastic! Thanks for your help.

>-----Original Message-----
>Tim,
>
>You might also want to take a look at Stephen Bullen's
VBE Tools add-in,
>which allows you to 'nudge controls
>
>http://www.oaltd.co.uk/VBETools/Default.htm
>
>--
>
>HTH
>
>RP
>(remove nothere from the email address if mailing direct)
>
>
>"Rob Bovey" <[email protected]> wrote in message
>news:[email protected]...
>> Hi Tim,
>>
>> You can't align the text in a Label control
vertically. You can,
>> however, turn off the grid. From the VBE menu choose
>Tools/Options/General.
>> Unchecking the "Align Controls to Grid" checkbox will
allow you to move
>> controls independent of the grid. Unchecking the "Show
Grid" checkbox will
>> hide the grid itself (these two settings are
independent).
>>
>> --
>> Rob Bovey, Excel MVP
>> Application Professionals
>> http://www.appspro.com/
>>
>> * Please post all replies to this newsgroup *
>> * Unsolicited e-mail replies will be ignored *
>>
>>
>> "Tim Archer" <[email protected]> wrote in
message
>> news:[email protected]...
>> >I have recently been starting to create user forms but
>> > have become frustrated by what I'm sure is a very
minor
>> > thing. When I make a label to indicate what a text
box
>> > is used for, the text within the label is always
justifed
>> > top left. I have found how to change the horizontal
>> > justification with TextAlign in Properties but I
can't
>> > find a way of centring the text vertically. Because
the
>> > controls all fit into the grid, all my labels do not
>> > align with the controls that they are associated
with.
>> >
>> > Question: how do I centre the text vertically? Or
can I
>> > turn off the grid?
>> >
>> > Many thanks for any help,
>> >
>> > Tim
>>
>>
>
>
>.
>