Show rows on listbox on form

[felipe0000]

Hi.
Im trying to make a manager for my non profit sports club. On the Attendance segment I want to pop up a form to do it in witch I add the date, select the class (Adults/Kids) and after that select on a listbox the members that showed up, but I need that the list contemplates only the active members only (Full name of the member only).
After that I want to add the new class date and attendance on a new column from the last class (to the left).

with this example

Im sorry not to be more specific.

 

[diddi]

hi and welcome to MrExcel
assuming you have a user form designed with a listbox called ListBox1. Assuming the Sheet is Called "Sheet 1"

Private Sub UserForm_Initialise()
    With Sheets("Sheet 1")
        For Row = 3 To .Cells(.Rows.Count, "A").End(xlUp).Row
            If .Cells(Row, 4) = "Active" Then
                ListBox1.AddItem .Cells(Row, 1) & " " & .Cells(Row, 2)
                ListBox1.List(ListBox1.ListIndex - 1, 1) = Row ' you will need an index to be able to save any data
            End If
        Next Row
    End With
End Sub

 

[felipe0000]

Thanks a lot!!! it looks shorter than I thought it would be.
only one question (i feel stupid). what do you mean with needing an index?

 

[diddi]

when the user chooses a name to edit... which row in the sheet will need to be changed?