Needless Horizontal scrollbar in Listbox
 

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

Needless Horizontal scrollbar in Listbox
 

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

--
Regards,
Tom Ogilvy


"Ken Soenen" wrote in message
...
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

Needless Horizontal scrollbar in Listbox
 

Thanks Tom. That did it.
ken

"Tom Ogilvy" wrote in message
...
Look at the columnwidth property. Make it less than the width of the
listbox.

--
Regards,
Tom Ogilvy


"Ken Soenen" wrote in message
...
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