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 2021: VBA Programming

Workbook 7

páginaprincipal.livro.por Dr. Peter J. Scharpff RI
64
páginaprincipal.livro.idioma:  English
This workbook shows you how to design and edit program code and forms in a number of practical examples. This way you can add extra functionality to spreadsheet program Excel 2021.
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
book.tabs.learning objectives

This workbook on programming in the Excel environment covers some of the more advanced applications and practical examples of VBA. The modules in a VBA project in Excel 2021 contain instructions and elements that can make use of existing data, objects, and tools such as sheets, tables, charts, or buttons. This requires advanced techniques in programming and editing code in the VBA development environment. This was discussed extensively in the previous workbook Excel 2021 VBA Macro Editor.

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 produced many publications on topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, drawing, audio, video and photo editing and the like.

  • About the author
  1. Introduction
    1. Design
    2. Notation
    3. Software
  2. Programming techniques
    1. Introduction
    2. Functions
    3. Decision structures
    4. Loops
    5. Key capturing
    6. Variables and constants
    7. Error trapping
    8. Exercise
  3. Integrating code
    1. Introduction
    2. Start
    3. Add-in
  4. 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
  5. Charts in vba
    1. Introduction
    2. The workbook
    3. Use of the VBA-app
  • That’s it
  • Appendix

Develop skills to modify existing code and write your own Excel functions and applications. Understand how to work with advanced Excel features like data tables and charts using VBA. Become proficient in integrating VBA code within Excel workbooks for added functionality. Gain knowledge in securing Excel VBA applications and controlling user interface interactions.

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