ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Vertical Alignment of text in Userform labels (https://www.excelbanter.com/excel-programming/301601-vertical-alignment-text-userform-labels.html)

dht

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

Michel Pierron[_2_]

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





All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com