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

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

--
Regards,
Tom Ogilvy


"Ken Soenen" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Thanks Tom. That did it.
ken

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> Look at the columnwidth property. Make it less than the width of the
> listbox.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Ken Soenen" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>