[HELP] Listbox in Excel Userform

[excelrocking]

Hi guys! I need help in populating my listbox with values from a worksheet.

Here's the userform:

And also, can you teach me how to ADD, EDIT, and DELETE selected items on the listbox.
In a way that it'll be added, edited, and deleted in both the listbox and worksheet.

 

[nightcrawler23]

Private Sub UserForm_Initialize()
lb1.ColumnCount = 5
Dim myArray(6, 5) As Integer
For i = 1 To 5
    For j = 1 To 5
        myArray(i - 1, j - 1) = Cells(i+1, j)
    Next j
Next i
lb1.List() = myArray
End Sub

Paste this in the initialize event of your userform. Umay need to modify the code a bit.

lb1 is the name of my listbox.

 

[nightcrawler23]

Private Sub CommandButton1_Click()
   lb1.RemoveItem (lb1.ListIndex)
End Sub

Use this to remove selected item from the list.