Cargando…
Excel Programming with VBA Starter.
Get started with programming in Excel using Visual Basic for Applications (VBA).
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2012.
|
| Colección: | Professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Excel Programming with VBA Starter; Excel Programming with VBA Starter; Credits; www.PacktPub.com; Support files, eBooks, discount offers and more; www.PacktLib. PacktPub.com; Why Subscribe?; Free Access for Packt account holders; 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 codeSaving a workbook containing macros; Adding a module; Browsing objects; Working with variables; The Immediate window; And that's it; Quick 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.
- TwitterAbout the author; About the reviewers.