|
|
CBIT
|
|
|
Sign In
|
|
|
|
|
|
|
|
|
|
Excel Macro with Visual Basic |
| Audience |
This course is designed for individuals interested in learning the skills necessary to use VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. |
| Description |
Upon successful completion of this course, individuals will be able to:
Run macros and explain the basics of a Visual Basic Module.
Create relative and absolute recorded macros and assign macros to various objects in a workbook.
Write procedures that test conditions and then run only certain statements based on the results.
Write procedures that execute one or more lines of code repetitively.
Store Excel macros so they are available in any workbook.
Create macros that interact with the user. |
| Prerequisites |
To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
Excel : Beginning, Intermediate, and Advanced |
| Pre-Work Required |
None |
| Suggested Class Size |
Minimum 3
Maximum 8 |
| Course Length |
8 hours |
|
|
Center for Business/Industry Training
brazosport college
500 College Drive, Lake Jackson, Texas 77566 979.230.3050
cbit@brazosport.edu
| |
|
|
|