Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Can column width be different sizes?

I have a multicolumn listbox, but only the 1st column needs to be set at
100pts. The other 4 columns are single digit numbers and it offsets the
listbox to have them in columns with 100pts as well. Is there any fix for
this?

Thanks
Thurman


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Can column width be different sizes?

Figures, after seaching for over a week now, I find the answer just after
posting my question...

Listbox1.ColumnWidths = "100;20;20;20;20"

"Thurman" wrote in message
et...
I have a multicolumn listbox, but only the 1st column needs to be set at
100pts. The other 4 columns are single digit numbers and it offsets the
listbox to have them in columns with 100pts as well. Is there any fix for
this?

Thanks
Thurman




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Can column width be different sizes?

where did you find it; in the question just before yours?

--
Regards,
Tom Ogilvy

Thurman wrote in message
et...
Figures, after seaching for over a week now, I find the answer just after
posting my question...

Listbox1.ColumnWidths = "100;20;20;20;20"

"Thurman" wrote in message
et...
I have a multicolumn listbox, but only the 1st column needs to be set at
100pts. The other 4 columns are single digit numbers and it offsets the
listbox to have them in columns with 100pts as well. Is there any fix

for
this?

Thanks
Thurman






Reply
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
Change Cell Width WITHOUT changing Column width dww701 Excel Discussion (Misc queries) 1 January 12th 09 10:52 PM
copying row/column sizes Gina Excel Discussion (Misc queries) 1 January 8th 09 05:26 PM
how can i see all column sizes at once not individually? Mary Lou Excel Discussion (Misc queries) 1 November 14th 07 07:55 PM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM
can we make a column width different sizes on the same page? karen Excel Discussion (Misc queries) 2 October 19th 05 10:08 PM


All times are GMT +1. The time now is 05:44 PM.

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"