Hello, everyone. I have searched for the following request/idea and I haven't seen any just yet. Anyway, might as well post about it.

I have a spreadsheet that uses a little VBA to hide/reveal rows via a button click. Pretty simple, really. However, I have two more ideas I want to apply to it.

1. I want to change the buttons to a listbox. The file is actually a performance report for individuals. Eventually, there will be a lot of them. For now, there are only 20. Is it possible to use a listbox referring to some hidden masterlist of names somewhere that hides/reveals the respective rows about the chosen name's data and still be able to have a check of what the choice was to activate the VBA for that name?

2. My VBA right now was pulled out of a simple method. However, it has one weakness. This is the code, btw:

Private Sub All_Click()
Dim TotalAllRng As Range

    Set TotalAllRng = Me.Range("A15:A40")
    
    TotalAllRng.EntireRow.Hidden = Not (TotalAllRng(1).EntireRow.Hidden)
End Sub
Basically, what it does is just hide/reveal rows A15 to A40. However, when I choose some other name, instead of hiding A15 to A40 and revealing, say, ONLY A68 to A94, what happens is it just "appends" to the data at hand, ie. showing A15:A40 and A68:A94 at the same time. I want to edit the code in such a way that it only shows one person at a time. Is this possible?

I think this is pretty basic so I won't upload a workbook for now. I can pretty much make my own listbox and all. My only problems are the reveal/hiding mechanism and how a listbox can be used for VBA.

Thanks for any and all help.