ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can column width be different sizes? (https://www.excelbanter.com/excel-programming/277651-can-column-width-different-sizes.html)

Thurman

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



Thurman

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





Tom Ogilvy

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








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

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