Sub 粘贴一个多行文字内容() 'Dim xlApp As Excel.Application 'Dim xlBook As Excel.WorkBook 'Dim xlSheet As Excel.Worksheet '在程序中操作EXCEL表常用命令: Set xlApp = CreateObject("Excel.Application")   ...
用MSForms控件的按钮可以控件数组,但由于是excel的控件,石乎不兼容CAD,是不是要建个Frame框架再放置按钮什么的? 'VBA动态生成控件数组并能响应事件 '用户窗体UserForm1: Private colCB As New Collection '表单按钮为集合 Private ctlCB As 类1 '类实例 Private Sub UserForm_Initialize() &n ...