使用Excel VBA实现数据模糊检索

Application of Excel VBA in Intelligent Data Query

文章阐述了一种使用VBA扩充Excel数据检索能力的方法,该方法可以实现对Excel数据表中任意单元格数据的模糊检索。其优点在于系统会根据输入检索关键字的变化,实时筛选出符合要求的数据;对于日常办公事务中海量Excel数据的检索需求有着重要的意义。

This article describes a method of using VBA to expand Excel data query ability, the method can realize the fuzzy query of data in any cell of Excel table. The advantage of this method is that system changes in real time according to the input keywords; this method has been widely used in daily office affairs.