Programming Excel with VBA : a practical real-world guide
(eBook)
Author
Published
Berkeley, CA : Apress, 2016.
Format
eBook
ISBN
1484222059, 9781484222058
Physical Desc
1 online resource (802 pages) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
UPC
10.1007/978-1-4842-2205-8
Notes
General Note
Includes index.
General Note
Using the VBA DoEvents Instruction.
Description
Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016. In this book, you will learn: How to interact with key Excel objects, such as the application object, workbook object, and range object Methods for working with ranges in detail using code Usage of Excel as a database repository How to exchange data between Excel applications How to use the Windows API to expand the capabilities of Excel A step-by-step method for producing your own custom Excel ribbon Who This Book Is For: Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Morgado, F. (2016). Programming Excel with VBA: a practical real-world guide . Apress.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Morgado, Flávio, 1989-. 2016. Programming Excel With VBA: A Practical Real-world Guide. Apress.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Morgado, Flávio, 1989-. Programming Excel With VBA: A Practical Real-world Guide Apress, 2016.
MLA Citation, 9th Edition (style guide)Morgado, Flávio. Programming Excel With VBA: A Practical Real-world Guide Apress, 2016.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
86add222-58e1-a5e5-b4dd-f4798dbcc751-eng
Grouping Information
| Grouped Work ID | 86add222-58e1-a5e5-b4dd-f4798dbcc751-eng |
|---|---|
| Full title | programming excel with vba a practical real world guide |
| Author | morgado flávio |
| Grouping Category | book |
| Last Update | 2024-09-06 16:31:08PM |
| Last Indexed | 2024-09-28 03:42:50AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Sep 24, 2024 |
| Last Used | Sep 24, 2024 |
Marc Record
| First Detected | Jul 29, 2024 04:02:41 PM |
|---|---|
| Last File Modification Time | Sep 06, 2024 04:37:25 PM |
MARC Record
| LEADER | 06831cam a2200541 i 4500 | ||
|---|---|---|---|
| 001 | ocn963661930 | ||
| 003 | OCoLC | ||
| 005 | 20240830103855.0 | ||
| 006 | m o d | ||
| 007 | cr bn|---aucuu | ||
| 008 | 161119s2016 caua o 001 0 eng d | ||
| 019 | |a 962751018|a 962794709|a 963608390|a 967683300|a 967713172|a 967767899|a 971087109|a 971245721|a 1005757352|a 1011790138|a 1026456867|a 1048232441|a 1058423044|a 1066652454|a 1066671757|a 1086569050|a 1103253797 | ||
| 020 | |a 1484222059|q (electronic bk.) | ||
| 020 | |a 9781484222058|q (electronic bk.) | ||
| 020 | |z 1484222040 | ||
| 020 | |z 9781484222041 | ||
| 024 | 7 | |a 10.1007/978-1-4842-2205-8|2 doi | |
| 035 | |a (OCoLC)963661930|z (OCoLC)962751018|z (OCoLC)962794709|z (OCoLC)963608390|z (OCoLC)967683300|z (OCoLC)967713172|z (OCoLC)967767899|z (OCoLC)971087109|z (OCoLC)971245721|z (OCoLC)1005757352|z (OCoLC)1011790138|z (OCoLC)1026456867|z (OCoLC)1048232441|z (OCoLC)1058423044|z (OCoLC)1066652454|z (OCoLC)1066671757|z (OCoLC)1086569050|z (OCoLC)1103253797 | ||
| 037 | |a 970032|b MIL | ||
| 040 | |a EBLCP|b eng|e rda|e pn|c EBLCP|d N$T|d IDEBK|d GW5XE|d OCLCQ|d OCLCF|d STF|d YDX|d UPM|d IDB|d ESU|d VT2|d N$T|d COO|d OCLCQ|d OCLCO|d IOG|d UAB|d K6U|d OTZ|d IAD|d JBG|d ICW|d ILO|d MERUC|d ICN|d LIV|d OCLCQ|d OCLCO|d U3W|d REB|d D6H|d CAUOI|d VVB|d KSU|d RRP|d AU@|d WYU|d UMI|d SFB|d NJR|d IUA|d CEF|d DEBBG|d LEAUB|d OCLCQ|d OH1|d OCLCQ|d UBY|d OCLCQ|d UKAHL|d OCLCQ|d BRF|d OCLCO|d OCLCQ|d OCLCO|d OCLCL | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a HF5548.4.M523|b M67 2016 | |
| 082 | 0 | 4 | |a 004 |
| 082 | 0 | 4 | |a 005.26/8|2 23 |
| 100 | 1 | |a Morgado, Flávio,|d 1989-|e author.|1 https://id.oclc.org/worldcat/entity/E39PCjrFtYvjDmw8JjYV3vQ7wP|0 http://id.loc.gov/authorities/names/no2014079684 | |
| 245 | 1 | 0 | |a Programming Excel with VBA :|b a practical real-world guide /|c Flavio Morgado. |
| 264 | 1 | |a Berkeley, CA :|b Apress,|c 2016. | |
| 300 | |a 1 online resource (802 pages) :|b illustrations | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 347 | |a text file | ||
| 347 | |b PDF | ||
| 500 | |a Includes index. | ||
| 500 | |a Using the VBA DoEvents Instruction. | ||
| 505 | 0 | |a At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Understanding Visual Basic for Applications (VBA); What Is Macro Code?; The VBA Environment; Modules: The VBA Documents; Standard and Class Modules; Class Modules; The VBA Language; Procedures: The VBA Code; Using Function and Sub Procedures; Calculating Age in Years; Test Procedure Codes Using VBA Immediate Window; Using Your Function Procedure Inside Excel; Executing Code Procedures Step-by-Step; Variable Declaration; Implicit vs. Explicit Variable Declaration. | |
| 505 | 8 | |a Using Option ExplicitVariable Types; Array Declares; Variable Scope and Lifetime; Using the Static Statement to Hold Any Variable Value; Using Code Module Variables; Using Private Code Module Variables; Create a Flow Chart for the Algorithm of Complex Procedures; Comment Your Code!; Using Public Code Module Variables; Public Procedures and Variables Constitute the Module Interface; Using Enumerators; Passing Arguments by Reference or by Value; Using a Naming Convention; Using Property Procedures; Property Procedures Allow Greater Control of Private Variables. | |
| 505 | 8 | |a VBA Statements, Functions, and InstructionsUsing VBA Instructions; VBA Logical Decision Instructions; Making Decisions with If & nd If Instructions; Making Decisions with the Select Case & nd Select Instruction; VBA Looping Statements; The For & ext Statement; The For Each & ext Statement; The While & nd and Do & oop Statements; Using Event Procedures; Using Class Modules; Declaring and Raising Events on Object Code Modules; Using VBA UserForms; The VBA Me Keyword; Evoking a VBA Procedure from an Excel Worksheet; Two Special VBA Functions: MsgBox and InputBox; Using MsgBox(); Using InputBox. | |
| 505 | 8 | |a Dealing with VBA ErrorsThe On Error Resume Next Instruction; Setting an Error Trap; Protecting Your VBA Code; Conclusion; Summary; Chapter 2: Programming the Microsoft Excel Application Object; The Microsoft Excel Object Model; The Application Object; Using Application Properties to Control the Way the Excel Interface Behaves; Using Application Methods to Show Excel File Dialogs; Using the FileDialog Method; Open One Single File; Open Many Files; Using the GetOpenFileName and GetSaveAsFileName Methods; Open One Single File; Open Many Files; Using Application InputBox Method. | |
| 505 | 8 | |a Using Application OnTime MethodUsing Application Events to React to User Actions; Creating an Excel. Application Object Reference; Firing Application Events; Using Class Modules to Control Application Object Events; Using a Class Module to Control Sheet Tab Name Changes; Chapter Summary; Chapter 3: Programming the Microsoft Excel Workbook Object; The Workbook Object; Using Workbook Object Events; Workbook Open Event and the frmSplashScreen UserForm; Implementing a UserForm Timer; Using the Application. OnTime Method; Using the VBA Timer() Function; Using the UserForm Repaint Method. | |
| 520 | |a Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016. In this book, you will learn: How to interact with key Excel objects, such as the application object, workbook object, and range object Methods for working with ranges in detail using code Usage of Excel as a database repository How to exchange data between Excel applications How to use the Windows API to expand the capabilities of Excel A step-by-step method for producing your own custom Excel ribbon Who This Book Is For: Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code. | ||
| 588 | 0 | |a Print version record. | |
| 630 | 0 | 0 | |a Microsoft Excel (Computer file)|0 http://id.loc.gov/authorities/names/n86025775 |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 fast |
| 650 | 0 | |a Visual Basic for Applications (Computer program language)|0 http://id.loc.gov/authorities/subjects/sh2014000894 | |
| 758 | |i has work:|a Programming Excel with VBA (Text)|1 https://id.oclc.org/worldcat/entity/E39PCGPbCkFKdQjQ9BbHkyv6Td|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version:|a Morgado, Flavio.|t Programming Excel with VBA : A Practical Real-World Guide.|d Berkeley, CA : Apress, ©2016|z 9781484222041|w (OCoLC)953223026 |
| 856 | 4 | 0 | |u https://www.aclib.us/OReilly |