Predictive text in a list

Hi All,

I am wondering how to enable predictive typing in a drop-down list.

There is a drop down list of about 20 items. It would be great if the user could enter the first couple of letters and excel would fill what it thinks is being typed. Can anyone help with this?

Thanks a lot.

B

Hello MAMC84,

If you are using a drop down from the Forms tool bar, this feature is not available. You would have have to use a Control Toolbox ComboBox control instead. It is standard feature for this control.

Sincerely,
Leith Ross