View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jim c. jim c. is offline
external usenet poster
 
Posts: 16
Default repost: Listbox text align

I have a single coulmn listbox on a userform. I would
like to right align the text displayed in the listbox, but
when listcount is greater than the viewable height of the
listbox the scrollbar hides part of the text. It seems
the text should right align to the scrollbar when it
appears. Is there a programmatic solution to this, or
will I have to add spaces to the end of the text to make
up the difference?