Abstract：Objective To explore the application of Excel VBA in data statistics of rehabilitation therapists.Methods The Excel VBA program embedded in Microsoft office was used to compile the code, and the corresponding forms, engineering files and modules were designed to enable the computer to complete the statistics of rehabilitation assessment, rehabilitation treatment, clinical examination and other data by the rehabilitation therapists.Results Through Excel VBA programming, we designed a data statistics program that met the clinical work needs of rehabilitation therapists. In this study, we recorded the complete basic information and treatment process of 534 rehabilitation patients. It provided a window interface for query and patient information input, which was automatically saved in a format that occupied less memory, enabling the rehabilitation therapists to quickly query the patients′ treatment process data and quickly accumulate the basic data of rehabilitation clinical research.Conclusion Using Excel VBA programming can improve the data statistics efficiency of rehabilitation therapists, reduce the error rate, improve the reliability of data, so as to improve the daily work efficiency and provide strong support for clinical research.
