excel vba 语言基础(vba 语言基础 excel).doc
《excel vba 语言基础(vba 语言基础 excel).doc》由会员分享,可在线阅读,更多相关《excel vba 语言基础(vba 语言基础 excel).doc(27页珍藏版)》请在三一文库上搜索。
1、excel vba 语言基础(vba 语言基础 excel)I. Basic VBA languageIdentifier1. definitionsAn identifier is a symbol that identifies variables, constants, processes, functions, classes, and other languages that can be completed by using themA reference to variables, constants, processes, functions, classes, etc.2.
2、naming rules1) initial letters, consisting of letters, numbers, and underscores, such as A987b_23Abc2) with VB reserved word names, such as public, private, dim, goto, next, with, integer, single etc.Operator1. mathematical operator + (plus), - (minus), Mod (take over), (divisible), * (x) / (except)
3、, (power)The 2. logical operators are Not (non), And (and), Or (or)3. relational operators (equal) =, (range), (greater than), (less than) = B, And, C250 ThenX = X-100EndifTwo选择案例语句结案例:选择PID控制“它”如果PID =“它”价格= 200案例“A102”如果PID =“A102”价格= 300caseelse”否则价格= 900结案?循环语句1。下一语句以指定次数来重复执行一组语句。1:例i = 1到10循环体
4、”表示我= 1,2,3,10依次执行循环体下一个我2:例i = 10到1步1循环体”表示我= 10,9,8,3,2,1依次执行循环体下一个我2。每一语句主要功能是对一个数组或集合对象进行,让所有元素重复执行一次语句。三.做而|直到环语句为当型循环(或而走),直到为直到型循环。例:做我10循环体”表示只要我10就反复执行循环体环注意,可以使用退出语句来退出为循环,用退出循环语句语句来退出做。4。与语句在一个单一对象上执行一系列的语句不用重复指出对象的名称。与对象声明结束?错误语句处理执行阶段有时会有错误的情况发生,利用OnError语句来处理错误,启动一个错误的处理程序。语法如下:OnError
5、 Goto线当错误发生时,会立刻转移到线行去接下来的当错误发生时OnError简历,会立刻转移到发生错误的下一行去onerro转到0当错误发生时,会立刻停止过程中任何错误处理过程?过程和函数过程是构成程序的一个模块,往往用来完成一个相对独立的功能。过程可以使程序更清晰、更具结构性。VBA具有四种过程:子过程、功能函数、财产属性过程和事件事件过程。1子过程。子过程是一系列由子和端子语句所包含起来的程序段,它们会执行动作却不能返回一个值。子过程可有参数,例如常数、变量、或是表达式等来调用它。如果一个子过程没有参数,则它的子语句必须包含一个空的圆括号。2。功能函数功能函数是一系列由功能和端功能所包含
6、起来的程序段,它们会执行动作并能返回一个值。功能可有参数,例如常数、变量、或是表达式等来调用它。如果一个功能没有参数,则它的功能语句必须包含一个空的圆括号。子和功能的参数有两种传递方式:按值传递(ByVal)和按地址传递(ByRef或省略)。3。物业属性过程和事件事件过程这是VB在对象功能上添加的两个过程,与对象特征密切相关,也是面向对象程序设计最重要的组成部分。?Excel VBA的基本概念1、工作簿:工作簿工作簿、activeworkbook、工作簿集合包含Excel工作簿中所有当前打开的Excel工作簿,亦即所有打开的Excel工作簿工作簿文件;对应中的成员,即其中的Excel文件;ac
7、tiveworkbook代表当前处于活动状态的工作簿,即当前显示的Excel工作簿代表其中有Visual Basic代码正在运行的工作簿文件。在具体使用中可用工作簿(指数)来引用工作簿对象,其中指数为工作簿名称或编号;Such as Workbooks (1) and Workbooks (annual report.Xls). The number is determined by the order in which you create or open the workbook. The first open workbook number is 1, and the second op
8、en workbook is 2.2, worksheet: Worksheets, Worksheet, ActiveSheetThe Worksheets collection contains all of the worksheet in the workbook, that is all the data pages in a Excel file; and Worksheet represents one of the work table; ActiveSheet represents the current in the active state of the work tab
9、le, which is currently showing a work table.The Worksheet object can be referenced by Worksheets (index), where index is the worksheet name or index number, such as Worksheets (1) and Worksheets (first quarter data). The worksheet index number indicates where the worksheet is in the worksheet tab: t
10、he first (leftmost) worksheet has an index of 1, and the last (rightmost) is Worksheets.Count. It should be noted that during use, Excel will automatically rearrange the worksheet index marks and keep them aligned from left to right in the worksheet labels, increasing the index number of the workshe
11、et. Therefore, the worksheet index quotes do not always remain unchanged due to the addition or deletion of possible worksheets.3, rows and columns: Rows, Columns, Row, ColumnThe Rows and Columns represent the active worksheet, cell range, Range, the specified number of rows in the worksheet, and th
12、e number of columns. For a multi cell area of Range Rows, Columns returns only the first region of the number of rows in the range, the number of columns. For example, if the Range object has two regions (areas), A1:B2, and C3:D4, Rows.Count returns 2 instead of 4.You can refer to the corresponding
13、rows and columns by Rows (line number) and Columns (column number). For example, Rows (3) and Columns (4) correspond to the third row and the D column, respectively.Using Rows and Columns, you can get the first line number, the first column number, and the decimal number of the first block in the re
14、gion.4, cells: Cells, ActiveCell, Range, AreasCells (row, column) stands for a single cell, where row is the line number and column is the column number. If you can use Cells (1,1) and Cells (10,4) to refer to the A1 and D10 cells. ActiveCell represents the active cell of the active worksheet, or th
15、e active cell that specifies the worksheet.Range represents a cell in a worksheet, a row, a column, a selected area (the selected area can contain one or several contiguous cell regions), or a three-dimensional region.You can use Range (ARG) to reference cells or cell ranges, where arg is the cell n
16、umber, cell number range, and cell area name. Such as Range (A5), Range (A1:H8) and Range (Criteria). Although Range (A1) can be used to return the cell A1, it is more convenient to use Cells because the rows and columns can be specified with variables at this time. Range can be used in conjunction
17、with Cells, such as Range (Cells (1,1), Cells (10,10), which represents the cell region, A1:J10.5, charts: Chart, Charts, ChartObject, ChartObjects, ActiveChartChart stands for the chart in the workbook. The chart can be either an embedded chart (included in ChartObject), or a separate (separate) ch
18、art worksheet.Charts represents a collection of all chart worksheets in a specified workbook or active workbook, but does not include diagrams embedded in the worksheet or dialog edit table. You can refer to a single Chart chart using Charts (index), where index is the index number or name of the ch
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- excel vba 语言基础vba 语言基础 excel 语言 基础
链接地址:https://www.31doc.com/p-11249665.html