Find Name in List Box

[Brian]

I have set up a worksheet to enter our club member names into
competition sheets. I have a list of a couple of hundred members
which is displayed in a list box. The member list is sorted
alphabitically. Once the name is selected a macro button is pressed
and the name selected is inserted in the next available place on the
competition sheet.
My problem is always having to scroll up and down this list box.
Is there a way to press the first letter of the name and go directly
to that part of the list box?
Bare in mind that the membership list changes continuouisly so I
cannot just define a range within the list.

 

[BrianB]

You probably need a combobox instead, with AutoWordSelect property True

 

[Dave Peterson]

Is this listbox on a worksheet?

If yes, did you use the listbox from the controls toolbox toolbar (or from the
Forms toolbar)?

If it's from the control toolbox toolbar on a worksheet (or in a userform), you
can go into design mode and rightclick on it and show its properties.

Scroll down to: MatchEntry
and change it to: 1 - fmMatchEntryFirstLetter

And try it out.

If you used a listbox from the Forms toolbar on that worksheet, then this won't
work.

 

[Brian]

Is this listbox on a worksheet?

If yes, did you use the listbox from the controls toolbox toolbar (or from the
Forms toolbar)?

If it's from the control toolbox toolbar on a worksheet (or in a userform), you
can go into design mode and rightclick on it and show its properties.

Scroll down to: MatchEntry
and change it to: 1 - fmMatchEntryFirstLetter

And try it out.

If you used a listbox from the Forms toolbar on that worksheet, then this won't
work.

Thanks for this. I have used a listbox from the Forms toolbar. I
will check how to change this to use the list box from the controls
toolbar to resolve the problem.