ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   resize Columnwidths Listbox (https://www.excelbanter.com/excel-programming/372602-resize-columnwidths-listbox.html)

Arjan

resize Columnwidths Listbox
 
Hi All,

CAn anyone help me?

I created a listbox with 4 columns. I changed the width of the first column
with the properties of the listbox.

but.. the question is; How can I change the width of columns number 2, 3 and
4?

thnks in advance..

--
Arjan Bregman
the Netherlands

Bob Phillips

resize Columnwidths Listbox
 
Set it in the Initialize or Activate event procedure

Me.ListBox1.ColumnWidths = "15;25;15;25"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arjan" wrote in message
...
Hi All,

CAn anyone help me?

I created a listbox with 4 columns. I changed the width of the first

column
with the properties of the listbox.

but.. the question is; How can I change the width of columns number 2, 3

and
4?

thnks in advance..

--
Arjan Bregman
the Netherlands




Arjan

resize Columnwidths Listbox
 
Bob,

thnx!! works great!!

Is there also a possibility to textalign the first colum to the left and the
other columns to the right?

Best regards,

Arjan


--
Arjan Bregman
the Netherlands


"Bob Phillips" wrote:

Set it in the Initialize or Activate event procedure

Me.ListBox1.ColumnWidths = "15;25;15;25"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arjan" wrote in message
...
Hi All,

CAn anyone help me?

I created a listbox with 4 columns. I changed the width of the first

column
with the properties of the listbox.

but.. the question is; How can I change the width of columns number 2, 3

and
4?

thnks in advance..

--
Arjan Bregman
the Netherlands





Bob Phillips

resize Columnwidths Listbox
 
I don't think so. You might be able to kludge it a bit, padding the data,
but nothing precise.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arjan" wrote in message
...
Bob,

thnx!! works great!!

Is there also a possibility to textalign the first colum to the left and

the
other columns to the right?

Best regards,

Arjan


--
Arjan Bregman
the Netherlands


"Bob Phillips" wrote:

Set it in the Initialize or Activate event procedure

Me.ListBox1.ColumnWidths = "15;25;15;25"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arjan" wrote in message
...
Hi All,

CAn anyone help me?

I created a listbox with 4 columns. I changed the width of the first

column
with the properties of the listbox.

but.. the question is; How can I change the width of columns number 2,

3
and
4?

thnks in advance..

--
Arjan Bregman
the Netherlands








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

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