Excel VBA in easy steps
Covers Visual Studio Community 2017
Seiten
2019
|
3rd edition
In Easy Steps Limited (Verlag)
978-1-84078-824-2 (ISBN)
In Easy Steps Limited (Verlag)
978-1-84078-824-2 (ISBN)
This book will help the reader gain a sound understanding of Visual Basic for Applications and be able to write their own VBA programs that can be executed in the Microsoft Excel Office application. No previous knowledge of any programming language is needed, so it's ideal for the newcomer to computer programming.
Excel VBA in easy steps neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. Areas covered include:
Recording and editing Macros
Creating your own Macro programs
Coding with the VBA language
Responding to Worksheet events
Programming Excel procedures
Making 'DataForms' for data editing
Producing 'UserForms' for data entry
Displaying dynamic Charts
Sharing your Excel apps to impress your colleagues!
Whether you're upgrading to Excel 2019, exploring Excel in the Office 365 suite, or new to the Macro programming concept, use this guide to learn the key features constructively and get more out of Microsoft Excel - in easy steps!
Excel VBA in easy steps neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. Areas covered include:
Recording and editing Macros
Creating your own Macro programs
Coding with the VBA language
Responding to Worksheet events
Programming Excel procedures
Making 'DataForms' for data editing
Producing 'UserForms' for data entry
Displaying dynamic Charts
Sharing your Excel apps to impress your colleagues!
Whether you're upgrading to Excel 2019, exploring Excel in the Office 365 suite, or new to the Macro programming concept, use this guide to learn the key features constructively and get more out of Microsoft Excel - in easy steps!
Mike McGrath now lives in South-east Europe, on the sun-kissed shores of the Aegean Sea. Mike gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world. His interests include coins of ancient Greece, dining-out with friends, and the ongoing evolution of the world wide web.
Getting started
Writing macros
Storing values
Performing operations
Making statements
Executing procedures
Employing functions 101
Recognizing events
Opening dialogs
Providing UserForm dialogs
Developing apps
| Erscheinungsdatum | 29.11.2018 |
|---|---|
| Reihe/Serie | In Easy Steps |
| Zusatzinfo | Full colour screenshots, photographs and diagrams |
| Verlagsort | Southam |
| Sprache | englisch |
| Maße | 186 x 227 mm |
| Themenwelt | Informatik ► Office Programme ► Excel |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| ISBN-10 | 1-84078-824-0 / 1840788240 |
| ISBN-13 | 978-1-84078-824-2 / 9781840788242 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
raffinierte Zaubereien für Excel-Kenner
Buch | Softcover (2024)
Markt + Technik (Verlag)
CHF 34,90
Komplett in Farbe. Ideal für alle Einsteiger, Umsteiger und auch …
Buch | Softcover (2022)
Markt + Technik Verlag
CHF 18,10
Datenanalyse und Reporting mit Power Query, Power Pivot und Power BI …
Buch (2023)
Carl Hanser (Verlag)
CHF 62,95
