Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
dht dht is offline
external usenet poster
 
Posts: 4
Default Vertical Alignment of text in Userform labels

Can anyone tell me how to set the vertical alignment of text in
userform labels in VBA in Excel 2000.

Thanks
Dave
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default Vertical Alignment of text in Userform labels

Hi Dave,
One possibility:
Private Sub UserForm_Initialize()
Me.Label1.Caption = "D" & vbLf & "A" & vbLf & "V" & vbLf & "E"
Me.Label1.AutoSize = True
End Sub

Regards,
MP

"dht" a écrit dans le message de
om...
Can anyone tell me how to set the vertical alignment of text in
userform labels in VBA in Excel 2000.

Thanks
Dave



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
In Cell alignment, how do I update the default vertical alignment How to update default cell alignment Setting up and Configuration of Excel 2 February 4th 09 02:25 PM
How do I change default vertical text alignment in Excel 2003? Harried User! Excel Discussion (Misc queries) 0 March 11th 08 05:35 PM
vertical text alignment problem when printing BobD2400 Excel Discussion (Misc queries) 1 January 20th 07 05:07 AM
I can't see all the text in a text box (vertical alignment)??? HornJM Excel Discussion (Misc queries) 3 January 26th 06 07:50 PM
Top alignment with vertical text? Al Excel Discussion (Misc queries) 2 December 6th 04 06:19 AM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"