D dht Jun 16, 2004 #1 Can anyone tell me how to set the vertical alignment of text in userform labels in VBA in Excel 2000. Thanks Dave
Can anyone tell me how to set the vertical alignment of text in userform labels in VBA in Excel 2000. Thanks Dave
M Michel Pierron Jun 16, 2004 #2 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
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