additem

  • Thread starter Thread starter ranswrt
  • Start date Start date
For multi column listBox use the list property in the UF initialize event.

Private Sub UserForm_Initialize()
ListBox1.List(0, 0) = "FirstRow, FirstCol"
ListBox1.List(0, 1) = "FirstRow, SecondCol"
ListBox1.List(0, 2) = "FirstRow, ThirdCol"
End Sub

Remember the row and column indexes are zero based. If you have a large
number of items to add, you might want to use list fill from a range.
 
I already have a listbox with items in it. I also have textboxes that get
the new data to add the the list box. What is the best way to add the new
data to the end of the list?
Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate Form Name to Parse for function 1
Variable Problem 3
list box remove item by combobox 4
Combo Box Question 22
Stopping duplications been entered into a listbox 8
Listbox Output to Individual Listboxes 1
How to fill a combo box with choice from another combo box 7
Userform Not working PLEASE HELP 3

Back
Top