View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default columns Widths for ComboBox

AvailableItems.ColumnWidths = "0;9;12;24"

But the measurement will be in points--not inches.

(I usually experiment to get the widths correct for my data.)

jlclyde wrote:

I am trying to set each column width seperately for my ComboBox on my
user form. I am not sure hwo to do this. This sets the first column
width. I need to do the other 4 columsn as well.

AvailableItems.ColumnWidths = "0 in;.9 in"

Thanks,
Jay


--

Dave Peterson