View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron[_2_] Michel Pierron[_2_] is offline
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