ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List Boxes (https://www.excelbanter.com/excel-programming/366976-list-boxes.html)

Murf

List Boxes
 
Does anyone know of a way of setting a listbox to allow the user to manually
adjust the column widths, or better yet anyway for the listbox to autosize
dependant on field lengths or even perform a word wrap?

Any help would be greatly appreciated,
Murf.

Tom Ogilvy

List Boxes
 
You can't wordwrap a listbox. You could loop through the list and count the
number of characters, then have your code adjust the list of the listbox.
this would be an approximation at best. Other than that you can use the
horizontal scrollbar by making the width of the box less than the width of
the column.

--
Regards,
Tom Ogilvy


"Murf" wrote:

Does anyone know of a way of setting a listbox to allow the user to manually
adjust the column widths, or better yet anyway for the listbox to autosize
dependant on field lengths or even perform a word wrap?

Any help would be greatly appreciated,
Murf.



All times are GMT +1. The time now is 07:26 PM.

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