Abstract:Land boundary survey is very important in carrying out the policy of "arable land protection and rational land use". Based on years of experience, by using VBA (Visual Basic for Application)in land surveying, through AutoCAD software, CAD macros has been established. Thus, automatically block coloring, ownership notes, square notes and block squares are summarized according to ownership and land class. It can effectively eliminate the possiblemanual errors in reading and writing.