LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 249
Default listbox - code to adjust column widths

[Excel 2003]
I use listboxes to display tables of data.

Is there a way to adjust individual column widths such that one can make the
columns fit - some of my columns need to be narrow and some wide.

Thus far I have only been able to make the first column width adjusted
(ColumnWidth Property) to what i want, but the others seem to be set to a
predefined default width.

Surely one can use code to adjust all the widths??

Roger
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto adjust column widths and row height DebC Excel Discussion (Misc queries) 1 November 24th 09 03:17 PM
AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT DebC Excel Worksheet Functions 3 June 5th 09 05:33 PM
Automatically adjust column widths stu_padassol Excel Discussion (Misc queries) 1 July 27th 06 08:13 AM
Column widths to adjust automatically? lambola Excel Discussion (Misc queries) 1 January 21st 05 12:35 AM
How do I adjust column widths only on selected cells? karla Excel Discussion (Misc queries) 2 December 27th 04 02:10 PM


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"