Posted to microsoft.public.excel.programming

Stephen Bullen[_4_] Stephen Bullen[_4_] is offline

external usenet poster

Posts: 205

Userform - Formating Text in a Label

Hi Teb2,

What can I do to make my text look centered in the label? Mine looks like it
is top centered?

Use two labels, one for the background/border, one (transparent) for the text
and center them with code:

lblFront.Top = lblBack.Top + (lblBack.Height - lblFront.Height) \ 2

and the same for the left/width

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Userform Label	Steve[_9_]	Excel Discussion (Misc queries)	7	October 29th 07 09:51 PM
Userform Label question	David Goodall	Excel Programming	2	October 29th 04 03:33 PM
Userform blinking label	Ed	Excel Programming	2	July 17th 04 12:24 AM
UserForm label doesn't load?	Ed[_18_]	Excel Programming	4	June 21st 04 07:53 PM
add text to label (label from forms toolbar)	Rob Bovey	Excel Programming	0	September 5th 03 09:46 PM

All times are GMT +1. The time now is 04:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us