Excel listbox additem multicolumn journal pdf

Re: Populate a multicolumn listbox? Switch from using a ListBox to using a ListViewyou can have as many columns, with nifty looking column headers I see how this works but my items are coming from a MySQL database. Using myCommand As New MySql.Data.MySqlClient.MySqlCommand ListBox1.ColumnCount = 2 ListBox1.AddItem "Item 1, Column 1" ListBox1.List(0, 1) = "Item 1, Column 2" 'snipetc End sub but i wanted a form with two command Re: multicolumn list box. Thanks Jeff, I'll check that out Mark "Jeff Mishler" wrote in message news:412256fc_3@newsprd01 > I have two textboxes and a multicolumn listbox on the form. User enters first name in one textbox and last name in the other. I've tried using listbox.additem function passing array as parameter, but that does not work. Any help would be greatly appreciated. Ich musste die Listbox wohl mit AddItem befullen. Okayweitergesucht und auch was gefunden. Leider klappt das nur fur Spalte A. Du kannst der List-Eigenschaft auch einen Range zuweisen der muss nicht statisch sein sondern kann z.B. alle belegten Zellen ermitteln und dann der With ListBox1 .AddItem .List(0, 0) = ActiveCell.Offset(0, 46).Value .List(0, 1) = ActiveCell.Value .List(0, 2) = ActiveCell.Offset(0, 48).Value .List(0, 3) = ActiveCell.Offset(0, 46).Address End With. Thanks for the help. It worked but, it only populates the first column of the multicolumn listbox. With Me.ListBox1 If Source.Cells(index , 1).Height <> 0 Then. .AddItem .List(index - 1, 0) = Source.Cells(index, 2) .List(index - 1, 1) A good way to learn how to navigate the object models of Word, Excel, and Powerpoint, based on what you want to do as a user, is to use the Macro Recorder.