![]() |
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 |
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 |
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 |
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