ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List Box format (https://www.excelbanter.com/excel-programming/284688-list-box-format.html)

Gordon C

List Box format
 
Hi...

I'm building list boxes into a user form but I don't want
the dimmed scroll bars to show...how can I remove them?

Thanks in advance...

GC

Cliff Myers

List Box format
 
Instead of using the listbox, use a combobox, under the combobox properties
set the showdropbuttonwhen to showdropbuttonwhennever.

HTH

"Gordon C" wrote in message
...
Hi...

I'm building list boxes into a user form but I don't want
the dimmed scroll bars to show...how can I remove them?

Thanks in advance...

GC





All times are GMT +1. The time now is 06:27 PM.

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