🗊Microsoft Excel 2007 - Illustrated

Категория: Информатика
Нажмите для полного просмотра!
Microsoft Excel 2007 - Illustrated, слайд №1Microsoft Excel 2007 - Illustrated, слайд №2Microsoft Excel 2007 - Illustrated, слайд №3Microsoft Excel 2007 - Illustrated, слайд №4Microsoft Excel 2007 - Illustrated, слайд №5Microsoft Excel 2007 - Illustrated, слайд №6Microsoft Excel 2007 - Illustrated, слайд №7Microsoft Excel 2007 - Illustrated, слайд №8Microsoft Excel 2007 - Illustrated, слайд №9Microsoft Excel 2007 - Illustrated, слайд №10Microsoft Excel 2007 - Illustrated, слайд №11Microsoft Excel 2007 - Illustrated, слайд №12Microsoft Excel 2007 - Illustrated, слайд №13Microsoft Excel 2007 - Illustrated, слайд №14Microsoft Excel 2007 - Illustrated, слайд №15Microsoft Excel 2007 - Illustrated, слайд №16Microsoft Excel 2007 - Illustrated, слайд №17Microsoft Excel 2007 - Illustrated, слайд №18Microsoft Excel 2007 - Illustrated, слайд №19Microsoft Excel 2007 - Illustrated, слайд №20Microsoft Excel 2007 - Illustrated, слайд №21Microsoft Excel 2007 - Illustrated, слайд №22Microsoft Excel 2007 - Illustrated, слайд №23
Скачать
Вы можете ознакомиться и скачать Microsoft Excel 2007 - Illustrated. Презентация содержит 23 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации

Слайд 1


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

Слайд 2


View VBA code View VBA code Analyze VBA code Write VBA code Add a conditional statement
Описание слайда:
View VBA code View VBA code Analyze VBA code Write VBA code Add a conditional statement

Слайд 3


Prompt the user for data Prompt the user for data Debug a macro Create a main procedure Run a main procedure
Описание слайда:
Prompt the user for data Prompt the user for data Debug a macro Create a main procedure Run a main procedure

Слайд 4


Unit Introduction Excel macros are written in a programming language called Visual Basic for Applications, or VBA Create a macro with the Excel macro recorder The recorder writes the VBA instructions for you Enter VBA instructions manually Sequence of VBA statements is called a procedure
Описание слайда:
Unit Introduction Excel macros are written in a programming language called Visual Basic for Applications, or VBA Create a macro with the Excel macro recorder The recorder writes the VBA instructions for you Enter VBA instructions manually Sequence of VBA statements is called a procedure

Слайд 5


Viewing VBA Code View existing VBA code to learn the language To view VBA code, open the Visual Basic Editor Contains a Project Explorer window, a Properties window, and a Code window VBA code appears in the Code window The first line of a procedure is called the procedure header Items displayed in blue are keywords Green notes explaining the code are called comments
Описание слайда:
Viewing VBA Code View existing VBA code to learn the language To view VBA code, open the Visual Basic Editor Contains a Project Explorer window, a Properties window, and a Code window VBA code appears in the Code window The first line of a procedure is called the procedure header Items displayed in blue are keywords Green 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 Editor A module is the Visual Basic equivalent of a worksheet Store macro procedures A module is stored in a workbook, or project, along with worksheets View and edit modules in the Visual Basic Editor
Описание слайда:
Viewing VBA Code (cont.) Understanding the Visual Basic Editor A module is the Visual Basic equivalent of a worksheet Store macro procedures A module is stored in a workbook, or project, along with worksheets View and edit modules in the Visual Basic Editor

Слайд 8


Analyzing VBA Code Analyzing VBA code Every element of Excel, including a range, is considered an object A range object represents a cell or a range of cells A property is an attribute of an object that defines one of the object’s characteristics, such as size The last line in VBA code is the procedure footer
Описание слайда:
Analyzing VBA Code Analyzing VBA code Every element of Excel, including a range, is considered an object A range object represents a cell or a range of cells A property is an attribute of an object that defines one of the object’s characteristics, such as size The 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 module to the workbook You must follow the formatting rules, or syntax, of the VBA programming language exactly A misspelled keyword of variable name will cause a procedure to fail
Описание слайда:
Writing VBA Code To write your own code, open the Visual Basic Editor and add a module to the workbook You must follow the formatting rules, or syntax, of the VBA programming language exactly A 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 AutoComplete To assist you in entering the VBA code, the Editor often displays a list of words that can be used in the macro statement Typically the list appears after you press period [.]
Описание слайда:
Writing VBA Code (cont.) Entering code using AutoComplete To assist you in entering the VBA code, the Editor often displays a list of words that can be used in the macro statement Typically the list appears after you press period [.]

Слайд 13


Adding a Conditional Statement Sometimes you may want a procedure to take an action based on a certain condition or set of conditions One way to add this type of statement is by using an If...Then…Else statement The syntax for this statement is: If condition then statements Else [else statements]
Описание слайда:
Adding a Conditional Statement Sometimes you may want a procedure to take an action based on a certain condition or set of conditions One way to add this type of statement is by using an If...Then…Else statement The syntax for this statement is: If condition then statements Else [else statements]

Слайд 14


Adding a Conditional Statement (cont.)
Описание слайда:
Adding a Conditional Statement (cont.)

Слайд 15


Prompting the User for Data When automating routine tasks, sometimes you need to pause a macro for user input Use the VBA InputBox function to display a dialog box that prompts the user for information A function is a predefined procedure that returns a value
Описание слайда:
Prompting the User for Data When automating routine tasks, sometimes you need to pause a macro for user input Use the VBA InputBox function to display a dialog box that prompts the user for information A 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 an error, called a bug, in the code To help you find bugs in a procedure, the Visual Basic Editor steps through the procedure’s code one line at a time When you locate an error, you can debug, or correct it
Описание слайда:
Debugging a Macro When a macro procedure does not run properly, it can be due to an error, called a bug, in the code To help you find bugs in a procedure, the Visual Basic Editor steps through the procedure’s code one line at a time When 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 into a procedure This is a main procedure To create a main procedure, type a Call statement for each procedure you want to run
Описание слайда:
Creating a Main Procedure Combine several macros that you routinely run together into a procedure This is a main procedure To 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 macros in sequence Run a main procedure as you would any other macro
Описание слайда:
Running a Main Procedure Running a main procedure allows you to run several macros in sequence Run a main procedure as you would any other macro

Слайд 22


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

Слайд 23


Summary Learn by viewing and analyzing VBA code Write VBA code using the Visual Basic Editor Use If..Then..Else statements for conditional actions Prompt user for data to automate input tasks Use the “Step Into” feature of the Visual Basic Editor to debug macros Use Main procedures to combine several macros
Описание слайда:
Summary Learn by viewing and analyzing VBA code Write VBA code using the Visual Basic Editor Use If..Then..Else statements for conditional actions Prompt user for data to automate input tasks Use the “Step Into” feature of the Visual Basic Editor to debug macros Use Main procedures to combine several macros

Скачать

Похожие презентации
Mypresentation.ru
Загрузить презентацию