View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Drom Drom is offline
external usenet poster
 
Posts: 1
Default Set the text align property of each individual column on UserForm1.ListBox1.ColumnCount = 5




Hi!

I have a UserForm "UserForm1"
This Userform has a ListBox "UserForm1.ListBox1"
This ListBox's, ClumnCount = 5, "UserForm1.ListBox1.ColumnCount = 5"

Now is it possible:
To set the text align property of each individual column ??

Kind of:
UserForm1.ListBox1.TextAlign = fmTextAlignRight
UserForm1.ListBox1.Column(3).TextAlign = fmTextAlignLeft
UserForm1.ListBox1.Column(5).TextAlign = fmTextAlignCenter

THANKS!!