ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   getting a horizontal scroll bar in listbox (https://www.excelbanter.com/excel-programming/354989-getting-horizontal-scroll-bar-listbox.html)

jmoffat[_27_]

getting a horizontal scroll bar in listbox
 

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


Tom Ogilvy

getting a horizontal scroll bar in listbox
 
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





All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com