Visual Basic for Applications (VBA)

Auteur : Robert Ekblaw
Durée 7h5
Date 2012-06-26

Acheter cette formation en téléchargement pour 79,00 €
Abonnez vous à l'ensemble des formations en VOD pour 30 € TTC /an

⊞ à propos de ce cours

The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. ...

Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE 		Formation téléchargeable
VISIONNAGE ILLIMITÉ

⊞ Fiche Technique

Formateur : Robert Ekblaw
Langue : Anglais
Durée : 7h5
Nombre de séquences vidéo : 80 		SKU : 34345
Réf :
ISBN : 978-1-61866-050-3
Date de publication : 2012-06-26
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :

The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. To begin learning today, simply click on the movie links.

⊞ Auteur

Robert Ekblaw

Robert Ekblaw is a professor in the Computer Science department at the University at Albany, part of the State University of New York. He has been a business and financial coach for over twenty years, specializing in computer-based tools to help organize and manage projects, people, and resources. He has taught thousands of people how to program and use computer applications. For twelve years he headed Breakthrough Consulting Services, one of the most highly-respected computer consulting companies in the Metropolitan New York City area.

Plan de formation

  • VBA Expressions

    • (04:46)
      Simple Arithmetic Operators
    • (04:39)
      Advanced Arithmetic Operators
    • (04:24)
      Comparison Operators
    • (06:08)
      Logical Operators
    • (05:14)
      Order of Operations
    • (08:09)
      Mathematical Expressions
    • (06:28)
      Using Functions in Formulas
    • (04:11)
      Mathematical Functions
    • (04:21)
      Conversion Functions
    • (06:37)
      String Functions
    • (07:56)
      Finding Words in Strings
    • (06:33)
      Replacing and Comparing Strings
    • (06:34)
      Sample Expressions
    • (05:31)
      Working with Dates
    • (06:49)
      Date Functions

  • Dialog Boxes

    • (05:55)
      User Interaction
    • (06:10)
      Using Message Boxes
    • (07:14)
      Format Options
    • (02:33)
      Results of Message Boxes
    • (06:48)
      Using Input Boxes

  • Functions and Procedures

    • (03:19)
      Creating a Subroutine
    • (04:16)
      Understanding Parameters
    • (05:06)
      Parameter Passing
    • (04:40)
      Function vs Procedure
    • (04:25)
      Return Statement
    • (03:23)
      Sample Function AVE
    • (03:30)
      Arrays as Parameters

  • Conditional Processing

    • (03:54)
      What Conditional Processing Is
    • (06:21)
      IF Block
    • (04:49)
      Complex Conditions
    • (06:02)
      Nested IFs and Elseif
    • (04:55)
      Using IF in Coin Toss
    • (06:49)
      Sample Function MIN
    • (05:42)
      Multiple Outcomes
    • (04:53)
      SELECT Block
    • (05:24)
      Multiple CASE Statements
    • (04:36)
      Conditional Functions

  • Loops

    • (04:24)
      Parts of a Loop
    • (04:14)
      Infinite Loops
    • (04:49)
      DO WHILE Loop
    • (05:03)
      DO UNTIL Loop
    • (05:46)
      FOR Loops
    • (04:55)
      Running Arrays
    • (07:38)
      Update AVE Function
    • (06:34)
      Sample Array Sort
    • (06:15)
      Sample Swap Routine
    • (05:48)
      Tracing FOR Loops
    • (06:35)
      Step Value in For Loops
    • (06:34)
      EXIT Statement

  • Testing Your Work

    • (05:10)
      The Debug Environment
    • (05:01)
      Seeing Values
    • (06:05)
      Stepping Through Code
    • (06:20)
      Breakpoints
    • (05:36)
      Finding and Fixing Errors

  • Conclusion

    • (04:05)
      What We Learned
    • (03:54)
      Planning for your VBA Code

  • Credits

    • (05:13)
      About the Author