VBA实现EXCEL数据录入有效性检查

Validity Check of Data Entry in EXCEL with VBA

本文阐述的是在EXCEL数据录入时,用VBA实现数据的有效性检查。主要针对用VBA如何实现对EXCEL数值型数据录入时的检查,也对其余类型数据录入的有效性检查提出了自己的看法。

The paper describes using VBA to realize data validity check while we input data into Excel worksheet.It mainly aims at using VBA for the validity check of the numberical data into Excel Worksheet,and also gives the opinion on the validity check for other types of data.