Hi All!

I have a listbox with three columns, I then have 2 text box and 1 combo box underneath.
and then three commands, Edit, Add and Delete.
I've worked out the code to make the textbox and combobox fill when i click on the name in the list box but I cannot get them to edit.

I also want to type an entry into the text boxes to add to the list

and delete a name in the list....

this is my code so far!!

Private Sub ListBox1_Click()
    With Me
        .txtUSERID.Value = .ListBox1.List(.ListBox1.ListIndex, 0)
        .txtNAME.Value = .ListBox1.List(.ListBox1.ListIndex, 1)
        .cboPERMISSION.Value = .ListBox1.List(.ListBox1.ListIndex, 2)
        End With
        
End Sub


Private Sub comEDIT_click()
Dim rCell As Range
Dim rCell1 As Range
Dim rCell2 As Range

With ListBox1
Set rCell = Range(.RowSource).Resize(1).Offset(.ListIndex, 0)
rCell.Value = txtUSERID.Value

Set rCell1 = Range(.RowSource).Resize(1).Offset(.ListIndex, 1)
rCell1.Value = txtNAME.Value

Set rCell2 = Range(.RowSource).Resize(1).Offset(.ListIndex, 2)
rCell2.Value = cboPERMISSION.Value
End With

End Sub

thanks!!!!!!