没有合适的资源?快使用搜索试试~ 我知道了~
首页Excel VBA Step-By-Step Guide 无水印pdf
Excel VBA Step-By-Step Guide 无水印pdf
需积分: 9 19 下载量 109 浏览量
更新于2023-03-16
评论
收藏 1.2MB PDF 举报
Excel VBA Step-By-Step Guide 英文无水印pdf pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除
资源详情
资源评论
资源推荐
EXCEL VBA
Step-By-Step Guide To Learning Excel
Programming Language For Beginners
Jason Jay
© Copyright 2017 by Jason Jay - All rights reserved.
If you would like to share this book with another person, please purchase an
additional copy for each recipient. Thank you for respecting the hard work of this
author. Otherwise, the transmission, duplication or reproduction of any of the
following work including specific information will be considered an illegal act
irrespective of if it is done electronically or in print. This extends to creating a
secondary or tertiary copy of the work or a recorded copy and is only allowed with
express written consent from the Publisher. All additional right reserved.
TABLE OF CONTENT
EXCEL VBA 1
Introduction 5
CHAPTER 1 7
VBA Developer TAB 7
Accesing to the Developer TAB 7
Quiz 1 8
CHAPTER 2 9
Macros 9
Creating a Macro 9
Relative References 11
Running the Macro 12
Saving a Macro-Enabled Workbook 12
Quiz 2 14
CHAPTER 3 16
Starting with VBA 16
What if I need to fill the cells up to 100? 19
Insert Form Button 21
Simple things a Macro can’t do. 22
Insert ActiveX Button 22
Variables, Do and Loop. 23
What is the advantage of declaring variables as byte, integer or any other? 31
APPs Performance 35
MSGBOX 39
If and Select Case 40
Quiz 3 43
CHAPTER 4 45
Project: Creating a Simple Calculator using ActiveX 45
What is a Module? 45
How to create a Module 46
Adding Letters? 58
Quiz 4 59
CHAPTER 5 60
Project: Calculator using Forms 60
Review 60
FORMS 61
Commmand Buttons code 65
Excel Formulas on VBA 74
Combining VBA and a Spreadsheet 75
Starting with Declarations: 78
Open and Close declarations: Displaying a form without looking any spreadsheet 81
Macro Security 87
Comments 89
The whole code for Calculator Project 94
Command Buttons Order 101
Adding Password to VBA Code. 102
Quiz 5 104
Interacting with other Applications. 105
Opening other apps from Excel 105
Sending an Outlook e-mail from Excel: 108
Exercises Solutions: 111
Answers Chapter 1 111
Answers Chapter 2 112
Answers Chapter 3 113
Answers Chapter 4 114
Answers Chapter 5 115
剩余98页未读,继续阅读
yinkaisheng-nj
- 粉丝: 763
- 资源: 6953
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- ExcelVBA中的Range和Cells用法说明.pdf
- 基于单片机的电梯控制模型设计.doc
- 主成分分析和因子分析.pptx
- 共享笔记服务系统论文.doc
- 基于数据治理体系的数据中台实践分享.pptx
- 变压器的铭牌和额定值.pptx
- 计算机网络课程设计报告--用winsock设计Ping应用程序.doc
- 高电压技术课件:第03章 液体和固体介质的电气特性.pdf
- Oracle商务智能精华介绍.pptx
- 基于单片机的输液滴速控制系统设计文档.doc
- dw考试题 5套.pdf
- 学生档案管理系统详细设计说明书.doc
- 操作系统PPT课件.pptx
- 智慧路边停车管理系统方案.pptx
- 【企业内控系列】企业内部控制之人力资源管理控制(17页).doc
- 温度传感器分类与特点.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0