Sign In
Excel Macros VBA - Level 1
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-Word Required
    None
     
    Suggested Class Size
    Minimum 3
    Maximum 12
     
    Course Length
    8 hours
       

    © 2015 Brazosport College | 500 College Drive | Lake Jackson, TX 77566 | (979) 230-3000 | Webmail | ASTRA | BC Alert | F.A.S. | Institutional Profile | Equal Opportunity | Login

    A lack of English language skills will not be a barrier to admission to and participation in career and technical education programs. Brazosport College shall not discriminate on the basis of race, creed, color, national origin, citizenship status, age, disability, pregnancy, religion, gender, gender identity, genetic information, marital status, veteran status or any other protected class in accordance with applicable federal and state laws. The following person has been designated to handle inquiries regarding the non-discrimination policies: Vice President of Human Resources, 500 College Drive, Lake Jackson, TX, 77566; 979-230-3459; Marshall.Campbell@brazosport.edu