一、问题描述
　　最近在开发一个Excel表格，遇到这样一个问题——记录有几千条，客户有几百个，怎样才能使用联想、模糊输入，快速登记数据。通过几天的查阅、思考，用公式和VBA综合解决了此问题。现将学习、研究的结果发上来供大家参考。
二、程序优点
1、数据源不需要排序，公式少；
2、不需要在表格中画TextBox、ListBox控件；
3、对Excel的复制、粘贴影响小；
4、代码少，轻松增加多表（如合同表、库存表等）；
5、输入速度快。
三、后续还可改进的地方
1、增加拼音、简拼搜索功能；
2、对表中同一列的已输入数据，实行联想、模糊输入。(1. Descr iption of the problem
Recently, in developing a Excel form, there is such a problem that there are thousands of records, and there are hundreds of customers. How can we use Lenovo and fuzzy input to register data quickly? Through consulting and thinking for several days, this problem has been solved by formula and VBA. The results of study and research are now given to you for reference.
Two. The advantages of the program
1. The data source does not need to be sorted, and the formula is less.
2, do not need to draw TextBox and ListBox controls in the form.
3, it has little influence on the copy and paste of Excel;
4, less code, easy to increase the multi table (such as contract table, inventory table, etc.);
5, the speed of input is fast.
Three, where the follow-up can be improved
1, increase the Pinyin, Jianpin search function;
2. The input data of the same column in the table, associative and fuzzy input are carried out.)