Can anyone help me to get a horizontal scroll bar into a listbox ?

My litbox is 180 point wide (set by width command) but my text i
wider.

I seem to remember if you set a small width in the .columnwidth
property you can generate a scroll bar - but this is ignored for
single column listbox, which is what I have.

If I reset the .Width property to something very small (eg 50) then
get the scroll bar but for some reason it doesn't scroll the fullwidt
of the text.

Any help greatly appreciated

--
jmoffa
-----------------------------------------------------------------------
jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115
View this thread: http://www.excelforum.com/showthread.php?threadid=51862

the width of the column (columnwidth property) should exceed the width of
the listbox. The columnwidth should accomodate the length of your text.

--
Regards,
Tom Ogilvy

"jmoffat" wrote in
message ...

Can anyone help me to get a horizontal scroll bar into a listbox ?

My litbox is 180 point wide (set by width command) but my text is
wider.

I seem to remember if you set a small width in the .columnwidths
property you can generate a scroll bar - but this is ignored for a
single column listbox, which is what I have.

If I reset the .Width property to something very small (eg 50) then I
get the scroll bar but for some reason it doesn't scroll the fullwidth
of the text.

Any help greatly appreciated.


--
jmoffat
------------------------------------------------------------------------
jmoffat's Profile:
http://www.excelforum.com/member.php...fo&userid=1151
View this thread: http://www.excelforum.com/showthread...hreadid=518624