ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   combo box on change code (https://www.excelbanter.com/excel-discussion-misc-queries/82451-combo-box-change-code.html)

frendabrenda1

combo box on change code
 
I have a combo box which has code attached to follow on change. Before that
code is attached a user can type the first 3 or so letters in the combobox,
and it will return the nearest value from the supplied list. After the code
is attached, the first letter entered returns the nearest value, and the
change macro is followed.

I am trying to find a way that a user can enter the first few letters before
choosing the closest value and running the change event code.

Any help is greatly appreciated.

Thank you!


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com