I have a workbook with a column like this:

NAME/CLASS
LASTNAME, FIRSTNAME (student's actual name goes here, all caps and BOLD)
Wellness
WRAP
Picking Up The Pieces
Understanding Your Medications
Understanding Your Symptoms
Anger Management
LIFTT
Supported Employment
Basic Computer
Intermediate Computer
Adult Basic Education
Creative Writing
Sign Language
Total Class Hours

This list repeats many times down the column for different students.

Currently I use Ctrl+F and type the first few letters of the last name to
navigate to a particular student's class group. I'm considering a userform
with a listbox populated with only their names that will make that
navigation easier as the students sign in for each class and they don't do
it in alphabetical order. I have to log each students class attendance
using those signin sheets each day. How could I pull the names only and put
them in my listbox on a so I could click on a name in that list and go to
that student's class range.

I'm not married to the idea of a listbox on a userform if other suggestions
would accomplish the same thing. An input box would not be any easier than
what I'm doing now.

--
David