Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
list boxes | Excel Programming | |||
List boxes/combo boxes | Excel Programming | |||
List Boxes (Help!) | Excel Programming |