Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Column Listbox Help Ken Excel Programming 0 December 20th 06 10:23 PM
Multi Column UserForm ListBox Mik Excel Programming 1 May 4th 06 10:10 PM
Dynamic Multi Column ListBox Ronbo Excel Programming 3 January 11th 05 07:59 PM
filling a two column listbox from a two column recordset Dennis Excel Programming 5 May 23rd 04 10:13 PM
populating a multi-column Listbox Harald Staff Excel Programming 1 April 26th 04 08:26 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"