Pre - emptive combo box.....

N

Neil

Hi All,

Here's a tricky one,

Is it possible to create a combo box type control within Excel that can
pre - empt your selection, ie. it auto completes your entry as you type ?

Thanks,

Neil
 
D

Dave Peterson

There is a combobox on the control toolbox toolbar that can be set this way.

Right click on that combobox and choose properties.

You'll want to change the style to: fmstyledropdownlist
and change the matchentry to: fmmatchentrycomplete

As well as setting linkedcell and listfillrange properties.
 
A

aaron.kempf

well.. to be honest; it doesnt really work in excel very well.. but
Access sure has a lot of options like that for data entry

you should uninstall Access, excel is a disease.. run away while you
still can
 
R

RagDyeR

<<<"you should uninstall Access">>>

Goes to prove, no matter how good or bad the software is,
It's the brain at the keyboard that effectuates the results.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

well.. to be honest; it doesnt really work in excel very well.. but
Access sure has a lot of options like that for data entry

you should uninstall Access, excel is a disease.. run away while you
still can
 
Top