Hi,
Even with the correct syntax I think you will have problems with
exceeding the limits of the control.
The help file say;
"Setting ColumnCount to 0 displays zero columns, and setting it to -1
displays all the available columns. For an unbound data source, there is
a 10-column limit (0 to 9)."
Cheers
Andy
Brandon Johnson wrote:
ok i did that and added this code and it showed just blanks all the way
down. A() is an array. it would be helpful to use the .column property
but i dont know how to use that correctly so im using this. its still
not working though. any thoughts
lstResults.AddItem A(1) & ";" & A(2) & ";" & A(3) & ";" & _
A(4) & ";" & A(5) & ";" & A(6) & ";" & A(7) & ";" & A(8) &
_
";" & A(9) & ";" & A(10) & ";" & A(11) & ";" & A(12) & ";"
& A(13)
Giles B wrote:
put semi-colons between each width:
0.75;0.75;0.75 etc.
"Brandon Johnson" wrote:
I have 13 columns id like to add. so i set the column count to 13 and
column bound to 0. I then put in 0.75 pt in the column width. How ever
do i do that 13 times or what do i do? can someone help please.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info