Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling a Multi-Column Listbox
Hello.
I wrote a code to fill a mulit-colum Listbox but I'd like the user to be able to move up and down the data. With one a column ListBox it's pretty easy I only have to use AddItem with the number row and automatically it push the data down. But I can't find a way to do it with a multi-colum ListBox, could someone please help me ? Thanks in advance! Nader |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling a Multi-Column Listbox
You want to first define an array, such as:
Dim MyData (1 to j, 1 to 4) Then something like this fills a 4-col listbox: With ListBox1 .ColumnCount = 4 .ColumnWidths = "100 pt;35 pt;40 pt;50 pt" .List = MyData .ListIndex = MyIndex End With ------ Cheers, Anony "Nader" wrote: Hello. I wrote a code to fill a mulit-colum Listbox but I'd like the user to be able to move up and down the data. With one a column ListBox it's pretty easy I only have to use AddItem with the number row and automatically it push the data down. But I can't find a way to do it with a multi-colum ListBox, could someone please help me ? Thanks in advance! Nader |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling a Multi-Column Listbox
I found the answer over at :
http://www.dicks-blog.com/archives/2...-in-a-listbox/ "Nader" a écrit dans le message de news: ... Hello. I wrote a code to fill a mulit-colum Listbox but I'd like the user to be able to move up and down the data. With one a column ListBox it's pretty easy I only have to use AddItem with the number row and automatically it push the data down. But I can't find a way to do it with a multi-colum ListBox, could someone please help me ? Thanks in advance! Nader |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Column Listbox Help | Excel Programming | |||
Multi Column UserForm ListBox | Excel Programming | |||
Dynamic Multi Column ListBox | Excel Programming | |||
filling a two column listbox from a two column recordset | Excel Programming | |||
populating a multi-column Listbox | Excel Programming |