Excel 2019 power programming with VBA / by Michael Alexander and Dick Kusleika, previously by John Walkenbach
By: Alexander, Michael.
Contributor(s): Kusleika, Dick.Publisher: Indianapolis, I.N. : John Wiley & Sons, 2019Description: xl, 742 p. : ill; electronic resource.ISBN: 9781119514923.Subject(s): Accounting software | Excel | Data management | Information technologyOnline resources: Download as an eBook
|Item type||Home library||Call number||URL||Status||Notes||Date due||Barcode||Item reserves|
|EBook||International||ProQuest eBook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
INTRODUCTION TO EXCEL VBA: Essentials of spreadsheet application development -- Introducing Visual Basic for applications -- VBA programming fundamentals -- Working with VBA sub procedures -- Creating function procedures -- Understanding Excel's events -- VBA programming examples and techniques. ADVANCED VBA TECHNIQUES: Working with pivot tables -- Working with charts -- Interacting with other applications -- Working with external data and files. WORKING WITH USERFORMS: Leveraging custom dialog boxes -- Introducing UserForms -- Looking at UserForm examples -- Implementing advanced UserForm techniques. DEVELOPING EXCEL APPLICATIONS: Creating and using add-ins -- Working with the ribbon -- Working with shortcut menus -- Providing help for your applications -- Leveraging class modules -- Understanding compatibility issues. APPENDIX: Appendix: VBA statements and functions reference.
Offers a complete introduction to Excel 2019 Visual Basic for Applications (VBA). Reveals how to leverage VBA to improve Excel programming skills. Offers tips, tricks and best practices and describes the interface, file formats, and the enhanced interactivity with other Office applications. Includes leverage templates and worksheets.