Abstract：Objective To design and implement a measurement management system for medical devices based on visual basic for
applications (VBA) technology. To improve the work efficiency of medical device measurement management personnel and reduce
the occurrence of missed and rechecked events. Methods Using the data derived from the medical device management software
and combining with the address book of our hospital, the medical device measurement database was established. Using Excel
2010 VBA embedded development friendly user interface, combined with form two-dimensional code technology, modulation
regulator technology and WeChat terminal to design and implement a medical device measurement management system with
remote interaction, data cascade and data orientation. Results The designed medical device management system realized in this
article had the functions of medical device account management, one-key dialing function, measurement feedback function, mobile
terminal information collection function, measurement device summary analysis function, metering certificate file management
and other functions. After the measurement management system was put into use, the device missed detection rate and re-detection
rate decreased by 0.83% and 8.83% respectively, and the device measurement qualified rate increased by 8.79%. The measurement
effect was significantly improved (P<0.05), and the satisfaction of service quality, completion time and overall satisfaction were
significantly improved (P<0.05). Conclusion The medical device measurement management system can simplify the management
process, achieve data interconnection, information sharing.The construction and implementation of medical device measurement
management information system from the perspective of “mobile office” can provide reference for the informatization, high
efficiency and standardization of medical device measurement management in hospitals, which has certain research significance and
promotion value.
李婷婷. 基于VBA技术的医疗器械计量管理系统的设计与实现[J]. 中国医疗设备, 2022, 37(1): 56-59.
LI Tingting. Design and Implementation of Medical Device Measurement
Management System Based on VBA Technology. China Medical Devices, 2022, 37(1): 56-59.
