Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting columnwidths | Excel Programming | |||
ColumnWidths property | Excel Programming | |||
PasteSpecial Paste:=ColumnWidths | Excel Programming | |||
Listbox refuses to resize | Excel Programming | |||
listbox.Columnwidths question | Excel Programming |