This is tool for the user to choose from a list. Its a combo box on a user form, but with two twists.
1) As the user types in the box, the list is filtered.
2) It is cast as a public function of the user form. The coding to call it.
The xlFilterStyle argument of the ChooseFromList function controls what kind of filtering xlBeginsWith, xlContains, xlEndsWith, xlDoesNotContain or xlNone.
And it allows for a default answer.
It also accepts ranges as the source of the list.
The four buttons show some ways of how it might be used.
If you "Choose a group", try to choose a group that contains Brendan.
I hope you find a use for this.