At the begining for VBA
来源:互联网 发布:于谦 知乎 编辑:程序博客网 时间:2024/06/05 06:31
http://www.excel-easy.com/vba.html
VBA
Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel.
1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simplemacro.
2 MsgBox: The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.
3 Workbook and Worksheet Object: Learn more about the Workbook and Worksheet object in Excel VBA.
4 Range Object: The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA.
5 Variables: This chapter teaches you how to declare, initialize and display a variable in Excel VBA.
6 If Then Statement: Use the If Then statement in Excel VBA to execute code lines if a specific condition is met.
7 Loop: Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.
8 Macro Errors: This chapter teaches you how to deal with macro errors in Excel.
9 String Manipulation: In this chapter you find the most important functions to manipulate strings in Excel VBA.
10 Date and Time: Learn how to work with dates and times in Excel VBA.
11 Events: Events are actions performed by users which trigger Excel VBA to execute code.
12 Array: An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number.
13 Function and Sub: In Excel VBA, a function can return a value while a sub cannot.
14 Application Object: The mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot of Excel related options.
15 ActiveX Controls: Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc.
16 Userform: This chapter teaches you how to create an Excel VBA Userform.
- At the begining for VBA
- At the Begining
- At the begining of Android development
- At The Begining Of Windows Azure
- The Begining
- The Begining
- The Begining
- The new begining
- the begining of coding
- Add the feature that can kill process at begining of each case
- THE FIRST DAY--THE BEGINING!
- One or more breakpoints cannot be set and have been disable.Execution will stop at the begining of the programe
- begining for my weibo life
- begining...
- Begining
- Begining
- Begining
- begining
- 刘书高谈为什么要学习网络营销
- mongoskin查询语句的写法
- 2、storage主流程
- Qt编译错误GL/gl.h: No such file or directory
- ORACLE 11G 32位 win7 完美安装图解
- At the begining for VBA
- rg.springframework<
- 3.编写一个截取字符串的函数
- org.springframework
- NET Framework
- FileUpload包下放了三个类:
- SQL语句中位与选择项的使用
- c++ 删除整形数组中重复的数字
- ARM Linux 3.x的设备树(Device Tree)