Find a person

[David]

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.

 

[ScottO]

It sounds like the Auto Filter would meet your objective.
Select a cell in your database, and go Data/Filter/Auto Filter.
Then select the name you want from the drop-down box at the top of the name column.
Rgds,
ScottO

| 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

 

[David]

ScottO wrote

It sounds like the Auto Filter would meet your objective.
Select a cell in your database, and go Data/Filter/Auto Filter.
Then select the name you want from the drop-down box at the top of the
name column. Rgds,
ScottO

I wish it were so, but I have to also have to have access to the class list
for that person once found.

 

[David]

David wrote

I'm not married to the idea of a listbox on a userform if other
suggestions would accomplish the same thing.

For now, here's what I did:

Ran Advanced Filter to find unique records in ColA, selected names and
copied to a helper column, set up an autoshape that when clicked ran this
macro after selecting target name in that helper column:

Sub FindName()
Columns("A:A").Find(ActiveCell.Text).Activate
End Sub

If anyone has a better idea, please chime in.

 

[Dave Peterson]

I'm not sure it's a better idea, but I like to put the key (name/id/something)

 

[David]

Dave Peterson wrote

I'm not sure it's a better idea, but I like to put the key
(name/id/something) on every row. It makes it easier to use
data|filter|autofilter, subtotals, pivottables

Thanks. Not sure how I could take advantage of any of those with my current
data and macro (several) structure, though. Never did like the appearance
of subtotals, nor did I ever grasp pivottables.