Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
Point (pt) is the default - but I don't think you want .75 - perhaps 75.
75;75;75;75;75;75;75;75;75;75;75;75;75 -- Regards, Tom Ogilvy "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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
ok tom that helped like big time. thankyou. i still have problem with
seperating them into different column now. thanks for the boost in headway. 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
with lstResults
.AddItem A(1) for j = 2 to 13 .list(.listcount - 1, j - 1) = A(j) Next End With -- Regards, Tom Ogilvy "Brandon Johnson" wrote: ok tom that helped like big time. thankyou. i still have problem with seperating them into different column now. thanks for the boost in headway. 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Column Count and Width Dont work. Seems Easy
Andy is correct (I was under the impression they had fixed this) - see my
answer to your later post for a work around. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote: with lstResults .AddItem A(1) for j = 2 to 13 .list(.listcount - 1, j - 1) = A(j) Next End With -- Regards, Tom Ogilvy "Brandon Johnson" wrote: ok tom that helped like big time. thankyou. i still have problem with seperating them into different column now. thanks for the boost in headway. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Autofit doesn't work when column not enough width | Excel Programming | |||
Autofit Row height or Column Width does not work | Excel Discussion (Misc queries) | |||
Column Width property does not work | Excel Programming | |||
Listbox that dont refresh automatically | Excel Programming |