View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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