This paper presents a method using VBA as a platform for research and development of micrometer calibrating certificate recording system (MCCRS) .It introduces the structure of the system and details the design of several key modules and the error proofing function of the system.The research and development of the MCCRS can reduce the workload,put an end to the artificially generated accidental errors and improve the labor efficiency.