- Category:
- Other systems
- Tags:
-
- File Size:
- 18kb
- Update:
- 2018-03-10
- Downloads:
- 0 Times
- Uploaded by:
- 资料总
Description: 1. Description 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.
To Search:
File list (Check if you may need any files):
| Filename | Size | Date |
|---|
| 模糊输入_PC.xls | 77824 | 2016-10-26 |
Download