Vertical Alignment of text in Userform labels

D

dht

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box text vertical alignment 2
Text alignment in User Forms 2
Vertical Center Alignment for Labels 5
Excel 2007 chart line width + axis labelling with VBA 6
Custom Angle and Alignment with VBA 1
Word How to rotate individual letters in word 2016 0
Excel 07 3D Column data label alignment 3
Can I realign all data labels in a chart at once 1

Top