Hi, I have a combo box which allows the user to select a firm from a
spreadsheet which is the first filter criteria used to run macros for
formatting and editing data for a report.

The list reference by the combo box is 1632 rows long. The combo box allows
you to scroll down to a value, although without the vertical scroll bar, and
select it. If I open the list in the combo box and I press the "M" key the
list does not automatically scroll to the first firm begining with M as in
other programs.

Is it possible to enable this action on a combo box?

Thanks in advance

Davie

Check out the Match Entry property in VBA help.

"davethewelder" wrote:

> Hi, I have a combo box which allows the user to select a firm from a
> spreadsheet which is the first filter criteria used to run macros for
> formatting and editing data for a report.
>
> The list reference by the combo box is 1632 rows long. The combo box allows
> you to scroll down to a value, although without the vertical scroll bar, and
> select it. If I open the list in the combo box and I press the "M" key the
> list does not automatically scroll to the first firm begining with M as in
> other programs.
>
> Is it possible to enable this action on a combo box?
>
> Thanks in advance
>
> Davie
>

I have looked at the match entry property in the vb help and I have done the
example and I understand how it works. My problem is that whereas the
example works in a form, my combo box is on a tab in the spreadsheet.

I don't know how to apply the Match Entry property to the combo box on the
tab and I don't know how to attach the drop down list to the form.


Any pointers greatly appreciated.

Davie

"JLGWhiz" wrote:

> Check out the Match Entry property in VBA help.
>
> "davethewelder" wrote:
>
> > Hi, I have a combo box which allows the user to select a firm from a
> > spreadsheet which is the first filter criteria used to run macros for
> > formatting and editing data for a report.
> >
> > The list reference by the combo box is 1632 rows long. The combo box allows
> > you to scroll down to a value, although without the vertical scroll bar, and
> > select it. If I open the list in the combo box and I press the "M" key the
> > list does not automatically scroll to the first firm begining with M as in
> > other programs.
> >
> > Is it possible to enable this action on a combo box?
> >
> > Thanks in advance
> >
> > Davie
> >