Lable

dantb · Mar 28th, 2002, 07:34 PM

When creating a Lable it seams to defalt to the most upper possition in the Lable box. Is there any Way to Center the Lable in the Box ?

Anne Troy · Mar 28th, 2002, 08:13 PM

What kind of label? A column heading, row heading, or a control toolbox label?

dantb · Mar 28th, 2002, 08:15 PM

A Lable in my vba User form, I can center it, but I can not center it Verticaly.

Dave Hawley · Mar 28th, 2002, 08:16 PM

Hi

I'm assuming Cotrol Label. In the Properties Window for the Label, scroll down to TextPosition.

dantb · Mar 28th, 2002, 08:19 PM

All I have in the Excell 2000 version is textAlign

Dave Hawley · Mar 28th, 2002, 08:27 PM

Sorry dantb

That's the one you want, not what I typed.

dantb · Mar 28th, 2002, 08:32 PM

I have clicked Center, but It does not center in the box (verticaly). It does not give that option, was just wondering if there was something else I could do the center Verticaly. Thx for your time. Dan

Dave Hawley · Mar 28th, 2002, 08:36 PM

No, it's only Horizontal. Does this matter? Labels are generally for Control headings and would not have a visible boundry (by defualt)

You can center you text However by pushing Ctrl+Enter before typing.

dantb · Mar 28th, 2002, 08:41 PM

Ok thanks Oz, will try and see what happens. Thanks again for your time, Have a good Evening !. Dan

Mar 28th, 2002, 08:13 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	What kind of label? A column heading, row heading, or a control toolbox label? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 07:34 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	When creating a Lable it seams to defalt to the most upper possition in the Lable box. Is there any Way to Center the Lable in the Box ?

Mar 28th, 2002, 08:15 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	A Lable in my vba User form, I can center it, but I can not center it Verticaly.

Mar 28th, 2002, 08:16 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi I'm assuming Cotrol Label. In the Properties Window for the Label, scroll down to TextPosition.

Mar 28th, 2002, 08:19 PM	#5
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	All I have in the Excell 2000 version is textAlign

Mar 28th, 2002, 08:27 PM	#6
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Sorry dantb That's the one you want, not what I typed.

Mar 28th, 2002, 08:32 PM	#7
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	I have clicked Center, but It does not center in the box (verticaly). It does not give that option, was just wondering if there was something else I could do the center Verticaly. Thx for your time. Dan

Mar 28th, 2002, 08:36 PM	#8
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	No, it's only Horizontal. Does this matter? Labels are generally for Control headings and would not have a visible boundry (by defualt) You can center you text However by pushing Ctrl+Enter before typing.

Mar 28th, 2002, 08:41 PM	#9
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Ok thanks Oz, will try and see what happens. Thanks again for your time, Have a good Evening !. Dan