Abstract: Raw material ratio and cost of modified urea formaldehyde(MUF)resin by melamine could be calculated automatically by the calculating system, which was compiled based on Excel VBA(visual basic for application) in this paper. And the calculating results were as same as the professional data processing software Matlab’s, this meant the calculating system based on Excel VBA is highly accurate and reliable. The calculating system had advantages of wide applicability, easy operation, generality and openness, which could also be extended to calculating the raw material ratio and the cost of phenol formaldehyde resin and melamine formaldehyde resin.