Resource estimation is not only an important basis for the development and utilization of mineral resources, but also one of the main achievements of mineral geological exploration. According to the degree of geological reliability, the types of resources can be divided into proven resources, controlled resources and inferred resources. From the exploration stage to the production stage, with the continuous deepening of mine field exploration, mine construction and production work, the estimation of resources will show dynamic changes. With the increasing amount of mineral resources exploration work, the workload and difficulty of judging the type of resource quantity will increase accordingly. With the help of AutoCAD VBA system to carry out modular programming, we can quickly and accurately judge the type of resource quantity, which plays an important role in promoting resource management.