Programming with VBA Excel - NL

Tijdsduur

Programming with VBA Excel - NL

Business Training N.V.
Logo van Business Training N.V.

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

Er zijn nog geen startdata bekend voor dit product.

Beschrijving

In this 3-day course, you will learn how to use Visual Basic to control Excel and to automate processes to speed up and simplify their work with Excel data. You will also learn how to create interactive procedures using message boxes and custom dialog boxes using Visual Basic controls...

Introduction

The advantages of VBA

  • An easy-to-use and versatile language
  • Integration into MS Office suite
  • Reduction of development time and costs

What mean VBA, macro and template

Macros: the first step

  • Recording and running simple macros
  • Limitations
  • Structuring complex macros

Getting to Know the VBA Development Environment

Visual Basic Editor

  • Project Explorer
  • Code Window
  • IntelliSens…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Excel VBA, VBA (Microsoft Office), Excel, Excel voor Financials en Excel basis / voor beginners.

In this 3-day course, you will learn how to use Visual Basic to control Excel and to automate processes to speed up and simplify their work with Excel data. You will also learn how to create interactive procedures using message boxes and custom dialog boxes using Visual Basic controls...

Introduction

The advantages of VBA

  • An easy-to-use and versatile language
  • Integration into MS Office suite
  • Reduction of development time and costs

What mean VBA, macro and template

Macros: the first step

  • Recording and running simple macros
  • Limitations
  • Structuring complex macros

Getting to Know the VBA Development Environment

Visual Basic Editor

  • Project Explorer
  • Code Window
  • IntelliSense
  • Help system
  • Properties Window
  • Object Browser

Debugging

  • Code stepping
  • Breakpoints
  • Immediate Window
  • Quick Watch
  • Locals Window 

Writing VBA code

Object-oriented programming

  • Objects
  • Methods
  • Properties
  • Parameters
  • With ... End With statement

Excel Object Model

  • Hierarchy
  • Collections
  • Referencing specific objects
  • VBA Excel methods and properties

Variables and constants

  • Declaration and assignment
  • Data types
  • Option explicit
  • Scope and lifetime of variables
  • Fixed and dynamic arrays

Conditional statements

  • If...Then...Else
  • Select...Case

Loop statements

  • Do ... While and Do … Until loops
  • For ... Next and For Each ... Next

Procedures

  • Sub and Function procedures
  • Call procedures

Event-driven programming

  • What are events?
  • Event procedures
  • Events linked to workbook and worksheets

Building Intuitive user interfaces

Using intrinsic dialogs

  • Message box
  • Input box

Creating customized dialogs with UserForm objects

  • Command buttons
  • Labels
  • Text boxes
  • List and Combo boxes
  • Option buttons
  • Check boxes
  • Frames
  • Advanced ActiveX controls

Working from Excel with other MS applications

  • Word
  • Outlook
  • Access with ActiveX Data Objects (ADO)

Providing a Safe and Secure Environment

Handling runtime errors

  • The On Error GoTo structure
  • Err object
  • Resume, Resume Next or Resume labels

Implementing security

  • The dangers of macro viruses
  • Macro security levels in MS Office
  • Trust Center
  • Password protection

Distributing procedures

  • Exporting and importing modules
  • Creating add-ins

Course benefits

They will also learn how to create interactive procedures using message boxes, and custom dialog boxes using Visual Basic controls. By the end of the course participants will have a good understanding of the Visual Basic language and the main elements of Excel that are referenced when using VBA.

This course is valuable for anyone who wants to automate tasks through VBA programming. Some experience using the products in the Microsoft Office System is assumed. No previous programming experience is required.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.