Abstract:

The consistent and standardized use of terms is of great significance in writing, translation, editing, proofreading, and review of scientific research papers and academic books. To achieve fast entry of terms, fuzzy query, and free and automatic annotation in local documents, the study designs a new system of term entry, query and labeling with a self-defined term base, which has the following functions: store self-defined terms with Excel workbooks, enter terms with form controls and VBA code, search terms with dynamic array function FILTER, and link Excel and Word with VBA code to achieve batch annotation of terms in documents. This system has a self-defined term base and allows for convenient entry of terms, instant querying of terms, and batch automatic annotation of local documents without additional software or internet connection. It is suitable for use in various scenarios such as writing, translation, editing, proofreading, and review.

Key words: self-defined term base, term entry, term query, term labeling, Excel VBA