目录
18.4 文字框 .........................................................................................................334
18.4.1 文字框常用属性 ................................................................................334 18.4.2 文字框的方法 ....................................................................................335
18.4.3 文字框常用事件 ................................................................................335 18.4.4 文字框实例——数据输入窗体 ...........................................................335 18.5 复选框 .........................................................................................................338
18.5.1 复选框属性 .......................................................................................338 18.5.2 复选框事件 .......................................................................................338 18.5.3 复选框实例——设置Excel选项.........................................................338 18.6 选项按钮......................................................................................................340
18.6.1 选项按钮常用属性 .............................................................................341 18.6.2 选项按钮常用事件 .............................................................................341 18.6.3 选项按钮实例——设置窗体字号和颜色 .............................................341 18.7 列表框 .........................................................................................................343
18.7.1 列表框常用属性 ................................................................................343 18.7.2 列表框的方法 ....................................................................................344 18.7.3 列表框实例——列表框间移动数据 ....................................................344 18.8 复合框 .........................................................................................................348
18.8.1 复合框常用属性 ................................................................................348 18.8.2 复合框常用方法 ................................................................................349 18.8.3 复合框常用事件 ................................................................................349 18.8.4 复合框实例——微机配置单 ...............................................................349 18.9 滚动条 .........................................................................................................351
18.9.1 滚动条常用属性 ................................................................................351 18.9.2 滚动条常用事件 ................................................................................352 18.9.3 滚动条实例——显示比例 ..................................................................352 18.10 旋转按钮 ....................................................................................................354
18.10.1 旋转按钮常用属性 ...........................................................................354 18.10.2 旋转按钮常用事件 ...........................................................................355 18.10.3 旋转按钮实例——修改日期和时间...................................................355 18.11 多页 ...........................................................................................................357
18.11.1 多页控件常用属性 ...........................................................................357 18.11.2 多页控件常用事件 ...........................................................................358 18.11.3 多页实例——报名登记 ....................................................................358 18.12 RefEdit .......................................................................................................359
18.12.1 RefEdit常用属性 .............................................................................360
18.12.2 RefEdit实例——设置单元格格式 .....................................................360
第19章 使用ActiveX控件 ...................................................................................... 362
·XVII·
Excel VBA开发技术大全
19.1 添加ActiveX控件 ........................................................................................362
19.1.1 什么是ActiveX控件 ..........................................................................362 19.1.2 添加ActiveX控件到工具箱 ...............................................................362 19.2 使用进度条控件 ...........................................................................................364
19.2.1 进度条控件的常用属性 ......................................................................364 19.2.2 进度条控件的方法 .............................................................................364 19.2.3 进度条实例——隐藏行 ......................................................................364 19.3 使用图像列表控件........................................................................................366
19.3.1 图像列表控件简介 .............................................................................366 19.3.2 图像列表控件的属性 .........................................................................367 19.3.3 图像列表控件的方法 .........................................................................367 19.3.4 添加图像到ImageList控件 ................................................................368 19.3.5 图像列表控件实例 .............................................................................369 19.4 使用树形视图控件........................................................................................372
19.4.1 树形视图控件简介 .............................................................................372 19.4.2 树形视图控件常用属性 ......................................................................373 19.4.3 树形视图控件的常用方法 ..................................................................374 19.4.4 树形视图控件常用事件 ......................................................................375 19.4.5 树形视图控件实例 .............................................................................375 19.5 使用列表视图控件........................................................................................380
19.5.1 列表视图简介 ....................................................................................380 19.5.2 列表视图控件常用属性 ......................................................................381
19.5.3 列表视图控件常用事件 ......................................................................382 19.5.4 列表视图控件实例 .............................................................................382
第20章 使用RibbonX............................................................................................. 387
20.1 了解Office（2007）Open XML文件格式......................................................387
20.1.1 Office Open XML的优点 ...................................................................387
20.1.2 Excel 2007 Open XML文件结构 .........................................................388 20.2 RibbonX控件简介 ........................................................................................392
20.2.1 基本控件 ...........................................................................................392 20.2.2 容器控件 ...........................................................................................393 20.2.3 控件属性 ...........................................................................................395 20.2.4 控件回调函数 ....................................................................................397 20.3 自定义RibbonX ...........................................................................................398
20.3.1 手工方式自定义RibbonX...................................................................398 20.3.2 使用UI编辑器自定义RibbonX..........................................................401 20.4 自定义RibbonX实例 ...................................................................................404
20.4.1 组合内置Ribbon ................................................................................404
·XVIII ·
目录
20.4.2 添加RibbonX到内置选项卡 ..............................................................406 20.4.3 定义Office按钮 ................................................................................407 20.4.4 RibbonX控件回调函数实例 ...............................................................409
第21章 使用CommandBars................................................................................... 413
21.1 CommandBar对象 ........................................................................................413
21.1.1 CommandBars简介 ............................................................................413
21.1.2 CommandBars对象常用属性 ..............................................................413 21.1.3 CommandBars对象常用方法 ..............................................................414 21.1.4 CommandBar对象常用属性 ...............................................................415 21.1.5 CommandBar对象常用方法 ...............................................................415 21.1.6 列出命令栏 .......................................................................................416 21.2 CommandBarControl对象 .............................................................................417
21.2.1 CommandBarControls集合对象 ..........................................................417 21.2.2 CommandBarControl对象...................................................................418 21.2.3 列出内置命令栏控件 .........................................................................419 21.3 自定义菜单 ..................................................................................................419
21.3.1 菜单的构成 .......................................................................................420 21.3.2 创建新菜单 .......................................................................................420 21.4 自定义快捷菜单 ...........................................................................................423
21.4.1 内置快捷菜单 ....................................................................................423 21.4.2 创建快捷菜单 ....................................................................................425 21.4.3 添加菜单项到内置快捷菜单 ...............................................................427 21.4.4 隐藏/禁止内置菜单项 ........................................................................429 21.5 自定义工具栏...............................................................................................431
21.5.1 内置工具栏 .......................................................................................431 21.5.2 创建工具栏 .......................................................................................432
第5部分 使用外部数据
.................................................................................. 436 第22章 控制其他Office程序
22.1 OLE自动化技术简介 ...................................................................................436
22.1.1 OLE简介 ..........................................................................................436 22.1.2 引用服务程序 ....................................................................................436 22.1.3 实例化对象变量 ................................................................................438
22.2 控制Word程序 ............................................................................................439
22.2.1 了解Word对象模型 ..........................................................................439 22.2.2 打开Word文档 .................................................................................440
·XIX·
Excel VBA开发技术大全
22.2.3 获取Word文档中的数据 ...................................................................442 22.2.4 批量创建Word文档 ..........................................................................443 22.3 控制PowerPoint程序 ...................................................................................448
22.3.1 了解PowerPoint对象模型 ..................................................................448 22.3.2 打开演示文稿 ....................................................................................449 22.3.3 创建演示文稿 ....................................................................................450 22.4 控制Outlook程序 ........................................................................................452
22.4.1 了解Outlook对象模型.......................................................................452
22.4.2 用Outlook发送邮件 ..........................................................................454 22.4.3 获取Outlook保存的邮件 ...................................................................456
.................................................................................................... 458 第23章 处理文件
23.1 常用文件操作语句........................................................................................458
23.1.1 文件管理语句 ....................................................................................458
23.1.2 创建文件语句 ....................................................................................460 23.1.3 向文件中写入数据 .............................................................................461 23.1.4 从文件中读出数据 .............................................................................462 23.2 文件对象模型...............................................................................................463
23.2.1 文件对象模型简介 .............................................................................463 23.2.2 引用FSO对象 ...................................................................................464 23.3 获得文件信息...............................................................................................465
23.3.1 获取磁盘信息 ....................................................................................465 23.3.2 查看文件信息 ....................................................................................467 23.4 文件管理......................................................................................................470
23.4.1 文件是否存在 ....................................................................................470 23.4.2 复制文件 ...........................................................................................471 23.4.3 分离文件名和扩展名 .........................................................................473 23.5 处理文件夹 ..................................................................................................474
23.5.1 创建文件夹 .......................................................................................474 23.5.2 列出文件夹中的文件 .........................................................................475 23.5.3 列出文件夹名称 ................................................................................476 23.5.4 删除所有空文件夹 .............................................................................476 23.6 处理文本文件...............................................................................................478
23.6.1 创建文本文件 ....................................................................................478 23.6.2 工作表保存为文本文件 ......................................................................479 23.6.3 添加数据到文本文件 .........................................................................480
23.6.4 读取文本文件中的数据 ......................................................................481
................................................................................ 483 第24章 使用ADO访问数据库
24.1 SQL结构查询概述 .......................................................................................483
·XX ·
相关推荐：
loading