Excel VBA程序开发自学宝典(第3版)案例文件

[{"title":"（ 329 个子文件 19.93MB ） Excel VBA程序开发自学宝典(第3版)案例文件","children":[{"title":"10-3 使用内置常量名称代替数值.xlsm <span style='color:#111;'> 19.38KB </span>","children":null,"spread":false},{"title":"10-2 代码缩进.xlsm <span style='color:#111;'> 14.20KB </span>","children":null,"spread":false},{"title":"10-4 并闭屏幕更新提升工作效率.xlsm <span style='color:#111;'> 155.64KB </span>","children":null,"spread":false},{"title":"10-5 使用With提升代码的书写效率和执行效率.xlsm <span style='color:#111;'> 14.73KB </span>","children":null,"spread":false},{"title":"10-6 对小于B1的单元格填充背景.xlsm <span style='color:#111;'> 188.14KB </span>","children":null,"spread":false},{"title":"10-1 代码分行.xlsm <span style='color:#111;'> 18.02KB </span>","children":null,"spread":false},{"title":"10-9 使用Replace简化字符串连接.xlsm <span style='color:#111;'> 14.79KB </span>","children":null,"spread":false},{"title":"10-8 用Instr函数简化字符串判断.xlsm <span style='color:#111;'> 14.59KB </span>","children":null,"spread":false},{"title":"10-7 使用带$的函数优化程序.xlsm <span style='color:#111;'> 15.09KB </span>","children":null,"spread":false},{"title":"6-4 删除活动单元格的值.xlsm <span style='color:#111;'> 15.75KB </span>","children":null,"spread":false},{"title":"6-5 将第1工作表的已用区域的值复制到第2个工作表.xlsm <span style='color:#111;'> 20.25KB </span>","children":null,"spread":false},{"title":"6-6 将三个工作表的细明数据复制到总表中.xlsm <span style='color:#111;'> 23.72KB </span>","children":null,"spread":false},{"title":"鼠标移过单元格时在状态栏显示地址.xlsm <span style='color:#111;'> 19.79KB </span>","children":null,"spread":false},{"title":"6-11 DrawingObjects应用.xlsm <span style='color:#111;'> 63.97KB </span>","children":null,"spread":false},{"title":"6-2 With语句的嵌套应用.xlsm <span style='color:#111;'> 15.30KB </span>","children":null,"spread":false},{"title":"6-8 Range.End属性的应用.xlsm <span style='color:#111;'> 14.72KB </span>","children":null,"spread":false},{"title":"6-7 在指定区域双击录入日期.xlsm <span style='color:#111;'> 15.85KB </span>","children":null,"spread":false},{"title":"6-3 颜色编码与颜色的对应关系.xlsm <span style='color:#111;'> 16.70KB </span>","children":null,"spread":false},{"title":"6-1 使用对象变量和With语句简化引用.xlsm <span style='color:#111;'> 16.08KB </span>","children":null,"spread":false},{"title":"6-9 获取指定坐标下的对象.xlsm <span style='color:#111;'> 146.69KB </span>","children":null,"spread":false},{"title":"6-10 图形对象名称.xlsm <span style='color:#111;'> 135.28KB </span>","children":null,"spread":false},{"title":"四车间.xlsx <span style='color:#111;'> 11.67KB </span>","children":null,"spread":false},{"title":"汇总表.xlsm <span style='color:#111;'> 16.64KB </span>","children":null,"spread":false},{"title":"二车间.xlsx <span style='color:#111;'> 11.76KB </span>","children":null,"spread":false},{"title":"三车间.xlsx <span style='color:#111;'> 11.73KB </span>","children":null,"spread":false},{"title":"一车间.xlsx <span style='color:#111;'> 11.67KB </span>","children":null,"spread":false},{"title":"1-1 一键提取身份证信息.xlsm <span style='color:#111;'> 115.92KB </span>","children":null,"spread":false},{"title":"数据录入助手.xlsm <span style='color:#111;'> 37.55KB </span>","children":null,"spread":false},{"title":"数据录入助手.xlam <span style='color:#111;'> 50.88KB </span>","children":null,"spread":false},{"title":"测试表.xlsx <span style='color:#111;'> 10.47KB </span>","children":null,"spread":false},{"title":"8-4 快速录入出勤表.xlsm <span style='color:#111;'> 18.72KB </span>","children":null,"spread":false},{"title":"8-1 自动宏.xlsm <span style='color:#111;'> 15.11KB </span>","children":null,"spread":false},{"title":"8-3 在状态栏提示最大值的单元格地址.xlsm <span style='color:#111;'> 14.74KB </span>","children":null,"spread":false},{"title":"8-12 阅读模式.xlsm <span style='color:#111;'> 21.88KB </span>","children":null,"spread":false},{"title":"8-10 自动设置工作表页眉.xlsm <span style='color:#111;'> 13.66KB </span>","children":null,"spread":false},{"title":"8-8 自动跳过公式区.xlsm <span style='color:#111;'> 21.02KB </span>","children":null,"spread":false},{"title":"8-6 在批注中存放所有修改记录.xlsm <span style='color:#111;'> 14.96KB </span>","children":null,"spread":false},{"title":"8-13 启用宏才能开启的工作簿.xlsm <span style='color:#111;'> 19.92KB </span>","children":null,"spread":false},{"title":"8-7 利用数字简化公司名称输入.xlsm <span style='color:#111;'> 15.75KB </span>","children":null,"spread":false},{"title":"8-5 选区字符统计.xlsm <span style='color:#111;'> 19.44KB </span>","children":null,"spread":false},{"title":"8-11 未汇总则禁止关闭工作簿.xlsm <span style='color:#111;'> 22.07KB </span>","children":null,"spread":false},{"title":"8-2 启用与禁用事件.xlsm <span style='color:#111;'> 17.54KB </span>","children":null,"spread":false},{"title":"8-9 背景着色.xlsm <span style='color:#111;'> 15.42KB </span>","children":null,"spread":false},{"title":"5-2 正确指定变量类型的优势.xlsm <span style='color:#111;'> 19.04KB </span>","children":null,"spread":false},{"title":"5-4 变量的作用域.xlsm <span style='color:#111;'> 14.66KB </span>","children":null,"spread":false},{"title":"5-1 三个数据类型错误案例.xlsm <span style='color:#111;'> 14.58KB </span>","children":null,"spread":false},{"title":"5-3 正确指定变量类型的优势2.xlsm <span style='color:#111;'> 17.46KB </span>","children":null,"spread":false},{"title":"5-5 三种错误的对象变量赋值方式.xlsm <span style='color:#111;'> 15.79KB </span>","children":null,"spread":false},{"title":"5-6 使用对象变量提升程序效率.xlsm <span style='color:#111;'> 16.91KB </span>","children":null,"spread":false},{"title":"16-9 按条件合并.xlsm <span style='color:#111;'> 17.02KB </span>","children":null,"spread":false},{"title":"16-1 根据业绩计算奖金.xlsm <span style='color:#111;'> 16.23KB </span>","children":null,"spread":false},{"title":"16-7 获取极值的地址.xlsm <span style='color:#111;'> 19.00KB </span>","children":null,"spread":false},{"title":"~$16-9 按条件合并.xlsm <span style='color:#111;'> 165B </span>","children":null,"spread":false},{"title":"16-11 按颜色对区域进行条件求和.xlsm <span style='color:#111;'> 18.95KB </span>","children":null,"spread":false},{"title":"16-3 计算当前页数.xlsm <span style='color:#111;'> 17.17KB </span>","children":null,"spread":false},{"title":"16-12 按颜色从左向向右查找所有数据.xlsm <span style='color:#111;'> 22.45KB </span>","children":null,"spread":false},{"title":"16-10 合并区域或数组的值.xlsm <span style='color:#111;'> 19.25KB </span>","children":null,"spread":false},{"title":"16-4 根据合并单元格合计数据.xlsm <span style='color:#111;'> 15.95KB </span>","children":null,"spread":false},{"title":"16-13 合计分隔符左边的所有数值.xlsm <span style='color:#111;'> 15.78KB </span>","children":null,"spread":false},{"title":"16-2 判断活动工作簿中是否有图形对象.xlsm <span style='color:#111;'> 648.80KB </span>","children":null,"spread":false},{"title":"16-5 创建工作表目录.xlsm <span style='color:#111;'> 4.90MB </span>","children":null,"spread":false},{"title":"16-6 分段提取数值.xlsm <span style='color:#111;'> 17.38KB </span>","children":null,"spread":false},{"title":"16-14 为函数分类及添加说明.xlsm <span style='color:#111;'> 17.91KB </span>","children":null,"spread":false},{"title":"16-8 对前N大值求和.xlsm <span style='color:#111;'> 16.23KB </span>","children":null,"spread":false},{"title":"2-2 调用子过程的五种方法.xlsm <span style='color:#111;'> 18.31KB </span>","children":null,"spread":false},{"title":"2-1 录制宏.xlsm <span style='color:#111;'> 428.16KB </span>","children":null,"spread":false},{"title":"14-14 贪婪匹配与惰性匹配.xlsm <span style='color:#111;'> 20.18KB </span>","children":null,"spread":false},{"title":"14-2 两个正则表达式模板.xlsm <span style='color:#111;'> 17.73KB </span>","children":null,"spread":false},{"title":"14-10 按指定长度匹配任意字符.xlsm <span style='color:#111;'> 13.90KB </span>","children":null,"spread":false},{"title":"14-5 贪婪匹配与惰性匹配.xlsm <span style='color:#111;'> 17.43KB </span>","children":null,"spread":false},{"title":"14-1 前期绑定与后期绑定.xlsm <span style='color:#111;'> 18.95KB </span>","children":null,"spread":false},{"title":"14-21 返回文件名与路径.xlsm <span style='color:#111;'> 18.10KB </span>","children":null,"spread":false},{"title":"14-20 获取Email地址.xlsm <span style='color:#111;'> 17.44KB </span>","children":null,"spread":false},{"title":"14-11 正向预查.xlsm <span style='color:#111;'> 14.07KB </span>","children":null,"spread":false},{"title":"14-13 负正向预查.xlsm <span style='color:#111;'> 17.24KB </span>","children":null,"spread":false},{"title":"14-12 正向预查应用2.xlsm <span style='color:#111;'> 19.98KB </span>","children":null,"spread":false},{"title":"14-23 分列的高级应用.xlsm <span style='color:#111;'> 19.88KB </span>","children":null,"spread":false},{"title":"14-3 删除字符串的所有数字.xlsm <span style='color:#111;'> 16.38KB </span>","children":null,"spread":false},{"title":"14-18 去除首尾空白字符.xlsm <span style='color:#111;'> 14.49KB </span>","children":null,"spread":false},{"title":"14-4 提取字符串的所有数字.xlsm <span style='color:#111;'> 17.50KB </span>","children":null,"spread":false},{"title":"14-15 汇总采购金额.xlsm <span style='color:#111;'> 17.72KB </span>","children":null,"spread":false},{"title":"14-19 数字分列.xlsm <span style='color:#111;'> 19.55KB </span>","children":null,"spread":false},{"title":"14-24 标示重复字词.xlsm <span style='color:#111;'> 27.16KB </span>","children":null,"spread":false},{"title":"14-17 汇总括号中的数值.xlsm <span style='color:#111;'> 20.07KB </span>","children":null,"spread":false},{"title":"14-22 仅汇总人民币.xlsm <span style='color:#111;'> 18.73KB </span>","children":null,"spread":false},{"title":"14-16 计算建筑面积.xlsm <span style='color:#111;'> 19.14KB </span>","children":null,"spread":false},{"title":"14-9 位置匹配.xlsm <span style='color:#111;'> 12.96KB </span>","children":null,"spread":false},{"title":"14-6 认识可选匹配.xlsm <span style='color:#111;'> 14.14KB </span>","children":null,"spread":false},{"title":"14-7 限量匹配.xlsm <span style='color:#111;'> 14.45KB </span>","children":null,"spread":false},{"title":"14-8 转换电话薄格式.xlsm <span style='color:#111;'> 17.22KB </span>","children":null,"spread":false},{"title":"17-15 设计启动LOGO.xlsm <span style='color:#111;'> 150.40KB </span>","children":null,"spread":false},{"title":"17-10 设计超链接.xlsm <span style='color:#111;'> 21.53KB </span>","children":null,"spread":false},{"title":"17-5 播放Flash动画.xlsm <span style='color:#111;'> 35.25KB </span>","children":null,"spread":false},{"title":"1.jpg <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"17-1 Excel 5.0对话框.xlsm <span style='color:#111;'> 16.68KB </span>","children":null,"spread":false},{"title":"17-17 设计计划任务向导.xlsm <span style='color:#111;'> 28.25KB </span>","children":null,"spread":false},{"title":"17-20 多工作表录入.xlsm <span style='color:#111;'> 32.02KB </span>","children":null,"spread":false},{"title":"17-3 使用代码为命令按钮指定Picture属性.xlsm <span style='color:#111;'> 14.12KB </span>","children":null,"spread":false},{"title":"17-7 双击时关闭窗体.xlsm <span style='color:#111;'> 19.10KB </span>","children":null,"spread":false},{"title":"17-14 为控件设置帮助信息.xlsm <span style='color:#111;'> 22.12KB </span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":"<span style='color:steelblue;'>文件过多，未全部展示</span>","children":null,"spread":false}],"spread":true}]