PPt4Web Хостинг презентаций

Главная / Информатика / Microsoft Excel 2007 - Programming with Excel
X Код для использования на сайте:

Скопируйте этот код и вставьте его на свой сайт

X

Чтобы скачать данную презентацию, порекомендуйте, пожалуйста, её своим друзьям в любой соц. сети.

После чего скачивание начнётся автоматически!

Кнопки:

Презентация на тему: Microsoft Excel 2007 - Programming with Excel


Скачать эту презентацию

Презентация на тему: Microsoft Excel 2007 - Programming with Excel


Скачать эту презентацию



№ слайда 1 Microsoft Excel 2007 -Illustrated Programming with Excel
Описание слайда:

Microsoft Excel 2007 -Illustrated Programming with Excel

№ слайда 2 Objectives View VBA codeAnalyze VBA codeWrite VBA codeAdd a conditional statemen
Описание слайда:

Objectives View VBA codeAnalyze VBA codeWrite VBA codeAdd a conditional statement

№ слайда 3 Objectives Prompt the user for dataDebug a macroCreate a main procedureRun a mai
Описание слайда:

Objectives Prompt the user for dataDebug a macroCreate a main procedureRun a main procedure

№ слайда 4 Unit Introduction Excel macros are written in a programming language called Visu
Описание слайда:

Unit Introduction Excel macros are written in a programming language called Visual Basic for Applications, or VBACreate a macro with the Excel macro recorderThe recorder writes the VBA instructions for youEnter VBA instructions manuallySequence of VBA statements is called a procedure

№ слайда 5 Viewing VBA Code View existing VBA code to learn the languageTo view VBA code, o
Описание слайда:

Viewing VBA Code View existing VBA code to learn the languageTo view VBA code, open the Visual Basic EditorContains a Project Explorer window, a Properties window, and a Code windowVBA code appears in the Code windowThe first line of a procedure is called the procedure headerItems displayed in blue are keywordsGreen notes explaining the code are called comments

№ слайда 6 Viewing VBA Code (cont.)
Описание слайда:

Viewing VBA Code (cont.)

№ слайда 7 Viewing VBA Code (cont.) Understanding the Visual Basic EditorA module is the Vi
Описание слайда:

Viewing VBA Code (cont.) Understanding the Visual Basic EditorA module is the Visual Basic equivalent of a worksheetStore macro proceduresA module is stored in a workbook, or project, along with worksheetsView and edit modules in the Visual Basic Editor

№ слайда 8 Analyzing VBA Code Analyzing VBA codeEvery element of Excel, including a range,
Описание слайда:

Analyzing VBA Code Analyzing VBA codeEvery element of Excel, including a range, is considered an objectA range object represents a cell or a range of cellsA property is an attribute of an object that defines one of the object’s characteristics, such as sizeThe last line in VBA code is the procedure footer

№ слайда 9 Analyzing VBA Code (cont.)
Описание слайда:

Analyzing VBA Code (cont.)

№ слайда 10 Writing VBA Code To write your own code, open the Visual Basic Editor and add a
Описание слайда:

Writing VBA Code To write your own code, open the Visual Basic Editor and add a module to the workbookYou must follow the formatting rules, or syntax, of the VBA programming language exactlyA misspelled keyword of variable name will cause a procedure to fail

№ слайда 11 Writing VBA Code (cont.)
Описание слайда:

Writing VBA Code (cont.)

№ слайда 12 Writing VBA Code (cont.) Entering code using AutoCompleteTo assist you in enteri
Описание слайда:

Writing VBA Code (cont.) Entering code using AutoCompleteTo assist you in entering the VBA code, the Editor often displays a list of words that can be used in the macro statementTypically the list appears after you press period [.]

№ слайда 13 Adding a Conditional Statement Sometimes you may want a procedure to take an act
Описание слайда:

Adding a Conditional Statement Sometimes you may want a procedure to take an action based on a certain condition or set of conditionsOne way to add this type of statement is by using an If...Then…Else statementThe syntax for this statement is: If condition then statements Else [else statements]

№ слайда 14 Adding a Conditional Statement (cont.) Elements of the If…then…Else statement ap
Описание слайда:

Adding a Conditional Statement (cont.) Elements of the If…then…Else statement appear in blue

№ слайда 15 Prompting the User for Data When automating routine tasks, sometimes you need to
Описание слайда:

Prompting the User for Data When automating routine tasks, sometimes you need to pause a macro for user inputUse the VBA InputBox function to display a dialog box that prompts the user for informationA function is a predefined procedure that returns a value

№ слайда 16 Prompting the User for Data (cont.)
Описание слайда:

Prompting the User for Data (cont.)

№ слайда 17 Debugging a Macro When a macro procedure does not run properly, it can be due to
Описание слайда:

Debugging a Macro When a macro procedure does not run properly, it can be due to an error, called a bug, in the codeTo help you find bugs in a procedure, the Visual Basic Editor steps through the procedure’s code one line at a timeWhen you locate an error, you can debug, or correct it

№ слайда 18 Debugging a Macro (cont.)
Описание слайда:

Debugging a Macro (cont.)

№ слайда 19 Creating a Main Procedure Combine several macros that you routinely run together
Описание слайда:

Creating a Main Procedure Combine several macros that you routinely run together into a procedureThis is a main procedureTo create a main procedure, type a Call statement for each procedure you want to run

№ слайда 20 Creating a Main Procedure (cont.)
Описание слайда:

Creating a Main Procedure (cont.)

№ слайда 21 Running a Main Procedure Running a main procedure allows you to run several macr
Описание слайда:

Running a Main Procedure Running a main procedure allows you to run several macros in sequenceRun a main procedure as you would any other macro

№ слайда 22 Running a Main Procedure (cont.) Printing Macro Procedures
Описание слайда:

Running a Main Procedure (cont.) Printing Macro Procedures

№ слайда 23 Summary Learn by viewing and analyzing VBA codeWrite VBA code using the Visual B
Описание слайда:

Summary Learn by viewing and analyzing VBA codeWrite VBA code using the Visual Basic EditorUse If..Then..Else statements for conditional actionsPrompt user for data to automate input tasksUse the “Step Into” feature of the Visual Basic Editor to debug macrosUse Main procedures to combine several macros

Скачать эту презентацию


Презентации по предмету
Презентации из категории
Лучшее на fresher.ru