VBA Userform Listbox

[Trickay]

Hi all, how can I make a listbox row source be from columns a to j until the last row that is not blank?

I am then wanting the columns to have borders in between them when being displayed on the listbox and a button to delete a row, and another button to add a row to an empty sheet inside the workbook

 

[richh]

Listboxes don't have internal borders, so you won't find a listbox that looks like a table.

To get the last filled row, you can find it a number of ways. Check this page for tips: VBA Tutorial: Find the Last Row, Column, or Cell in Excel

Then, create a For loop to populate your listbox with each row's data

Adding/Deleting rows is harder.

To delete, you'll need a function to find the selected item in the listbox and then the row associated with that element. I suggest that you create a multicolumn listbox. In one of the columns, store the row number and set its width to 0. Then when you wan t to delete the row, you don't have to search for it, you can use the row number stored in the listbox.

To add, you'll need a function to find the last row, input some data element, then requery the listbox.

 

[Trickay]

Thank you for your reply. Maybe I should have a second userform pop out when the row on the list box is double clicked, and all of that information go into text boxes. Then from there I can already get the text boxes to do what I need.