Excel programming with VBA starter get started with programming in Excel using Visual Basic for Applications (VBA)
Get started with programming in Excel using Visual Basic for Applications (VBA).
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, Eng. :
Packt Publishing
2012.
|
| Edición: | 1st edition |
| Colección: | Professional expertise distilled
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628588606719 |
Tabla de Contenidos:
- Cover; Copyright; Credits; www.PacktPub.com; www.PacktLib.PacktPub.com; Table of Contents; Excel Programming with VBA Starter; So, what is VBA?; The basic features of VBA; What kind of things can you do with it?; How can you use this technology within your existing projects?; Recording a macro, adding modules, browsing objects, and variables; Recording a macro; Option 1 - Recording a macro from the status bar; Option 2 - Recording from the Developer tab; Executing your code; Saving a workbook containing macros; Adding a module; Browsing objects; Working with variables; The Immediate window
- And that's itQuick start - VBA programming; Working with loops; Method 1 - For-Next loops; Method 2 - For Each-Next Loops; Method 3 - Do-While and Do-Until loops; Dimensioning and instantiating objects; Subroutines and user-defined functions; Subroutines; Functions; Top features you'll want to know about; Enumeration; Classes; External libraries; People and places you should get to know; Official sites; Resources; Articles and tutorials; Community; Blogs; Twitter; Index
