用Excel VBA快速录入轧辊数据  

Quick inputting roll data using Excel VBA

作　　者：刘双喜[1] 李魁猛[1] 肖连华[1] 任学平[2] 

机构地区：[1]唐山钢铁集团重机装备有限公司,河北唐山063306 [2]北京科技大学材料学院,北京100083

出　　处：《锻压技术》2011年第6期149-153,共5页Forging & Stamping Technology

摘　　要：轧辊数据电脑录入的工作量是很繁重的,有的还要不断地切换输入法,很容易出错。本文利用Excel VBA编程技术,通过添加组合框、窗体等控件录入轧辊类型、厂家、规格、材质、图号等数据,实现了一次录入多次调用,保证了录入数据的准确性、一致性,大大提高了录入速度。The work load of inputting the roll recording data into computer is heavy,and sometime it needs to shift the input method continually which is easy to make mistakes.Using the Excel VBA programming technology,by means of adding the combo box,forms,etc.,were rapidly input roll type,manufacturer,specification,material,drawing number,etc.,one entry and more calls were realized,the accuracy and consistency of entry data were guaranteed and the speed of entry was greatly improved.

关 键 词：轧辊 VBA EXCEL 快速录入 自动完成 VBE 

分 类 号：TG333.17[金属学及工艺—金属压力加工] TP391.13[自动化与计算机技术—计算机应用技术]