I read an article here:
http://www.contextures.com/xlDataVal14.html
Don't bother to read it. Just download the sample file available at the bottom of that page. (Here it is: http://www.contextures.com/DataValComboboxClick.zip )
I noticed that the Auto-complete feature works only if one clicks in the combo box. Is there a way to make this a keyboard only affair?
Thanks.
http://www.contextures.com/xlDataVal14.html
Don't bother to read it. Just download the sample file available at the bottom of that page. (Here it is: http://www.contextures.com/DataValComboboxClick.zip )
I noticed that the Auto-complete feature works only if one clicks in the combo box. Is there a way to make this a keyboard only affair?
Thanks.