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