Fazer login Experimenta grátis

Follow us

Bem-vindo à Bookboon

De modo a conseguirmos garantir os nossos serviços, precisamos de alguns cookies essenciais para aceder às nossas funcionalidades.

See Cookies Details
categorias empresarial
páginaprincipal.livro.e-book_profissional

Excel 2019 VBA Programming

páginaprincipal.livro.por Dr. Peter J. Scharpff RI
117
páginaprincipal.livro.idioma:  English
Learn in this ebook to edit (recorded) macros and to design software code and forms to add additional functionality to the popular Excel spreadsheet program.
Subscrição Profissional Plus grátis durante os primeiros 30 dias, após esse período $6.99/mês
Sem anúncios dentro do livro
Descrição
Conteúdos

Excel has a powerful toolbox and a lot of functionality. So why creating own applications in such an extensive computer program ... just to automate routine tasks? There’s more than just that, you can develop more functionality with programming language VBA. It allows you to customize recorded macros as desired, and for example, provide custom elements or dialogs for communication with the user about the execution of the program. Consider questions like "What is the initial value for the calculation?", "Where is the data?" or 'What report do you want to print?'.This ebook shows you to create your own applications, to edit (recorded) macros and to add all sorts of own functionality to the spreadsheet program.

About the author

Peter Scharpff originates from the scientific computer-linguistic field focussing on the interaction between man and machine, especially on speech and language engineering. After that he started to develop training material for office automation. In the last few decades he has also created many publications on more general topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, and the like.

  • About the author
  1. Introduction
    1. Structure
    2. Notation
    3. Software
  2. Development environment
    1. Introduction
    2. Developer tab
  3. Macros
    1. Introduction
    2. Recording a macro
    3. Running a macro
    4. Relative Reference
    5. Exercise
  4. Programming
    1. Introduction
    2. Creating Programs
    3. Objects
    4. Program structures
    5. Variables
    6. Comments
  5. The VBA Editor
    1. Introduction
    2. What’s in the window?
    3. Working windows
  6. Generating Code
    1. Introduction
    2. Recording
    3. Editing Code
    4. Forms
  7. Overview
    1. Introduction
    2. Hungarian notation
    3. Immediate window
    4. Object Browser
    5. Exercise
  8. Programming techniques
    1. Introduction
    2. Functions
    3. Decision structures
    4. Loops
    5. Key capturing
    6. Variables and constants
    7. Error trapping
    8. Exercise
  9. Integrating code
    1. Introduction
    2. Start
    3. Add-in
  10. Case: an invoice model
    1. Introduction
    2. The invoice workbook
    3. The invoice form
    4. Creating the invoice
    5. Security
    6. User Interface
    7. Extra exercise
  11. Charts in VBA
    1. Introduction
    2. The workbook
    3. Use of the VBA-app
  • Appendix
Escrever uma opinião
páginaprincipal.livro.sobre_autor
Dr.

Dr. Peter J. Scharpff RI

páginaprincipal.livro.descobrir_autor
páginaprincipal.livro.conteúdo_relacionado