Abstract: Coal drilling comprehensive results analysis and statistical calculations are important foundation works of correlation of histogram drawing, coal seams and coal reserves calculation. Although the traditional analyses work has used Excel, manual processing is demanding. VBA language is embedded in the EXCEL and easy to grasp, and development of the related calculation program can greatly improve the efficiency of the technical staff. A comprehensive results analysis program has been developed with VBA and has been applied in the project of coal exploration area design in Jiegou of Hezhang County, Guizhou Province. Practice has proved that the program is efficient and has high accuracy.