Needless Horizontal scrollbar in Listbox

[Ken Soenen]

What determines the presence of a Horizontal scrollbar on a Listbox? I would
think it would be dependent on the width of the longest string you put in.
But, it doesn't appear that way. The longest string I put in is one
character long with a font size of 9. The width of the listbox has to be
jacked all the way up to 80 to get rid of the scrollbar.

I'm running with Excel 2003.
Any ideas?

thanks,
ken

 

[Tom Ogilvy]

Look at the columnwidth property. Make it less than the width of the
listbox.

 

[Ken Soenen]

Thanks Tom. That did it.
ken

Look at the columnwidth property. Make it less than the width of the
listbox.