轧辊数据电脑录入的工作量是很繁重的,有的还要不断地切换输入法,很容易出错。本文利用Excel VBA编程技术,通过添加组合框、窗体等控件录入轧辊类型、厂家、规格、材质、图号等数据,实现了一次录入多次调用,保证了录入数据的准确性、一致性,大大提高了录入速度。 Roll data computer input workload is very heavy, and some continue to switch the input method, it is easy to make mistakes. In this paper, we use Excel VBA programming technology to input the data of roll type, manufacturer, specification, material, drawing number and so on by adding combobox, form and other controls to achieve the accuracy of the input data accuracy, consistency, Greatly increased the speed of entry.