000764335 000__ 04650cam\a2200505Mi\4500
000764335 001__ 764335
000764335 005__ 20230306142411.0
000764335 006__ m\\\\\o\\d\\\\\\\\
000764335 007__ cr\bn\nnnunnun
000764335 008__ 161119s2016\\\\cau\\\\\o\\\\\000\0\eng\d
000764335 019__ $$a962751018$$a963608390
000764335 020__ $$a9781484222058$$q(electronic book)
000764335 020__ $$a1484222059$$q(electronic book)
000764335 020__ $$z9781484222041
000764335 020__ $$z1484222040
000764335 035__ $$aSP(OCoLC)ocn963661930
000764335 035__ $$aSP(OCoLC)963661930$$z(OCoLC)962751018$$z(OCoLC)963608390
000764335 040__ $$aEBLCP$$beng$$epn$$cEBLCP$$dN$T$$dIDEBK$$dGW5XE$$dOCLCQ$$dOCLCF
000764335 049__ $$aISEA
000764335 050_4 $$aHF5548.4.M523
000764335 050_4 $$aQA75.5-76.95
000764335 08204 $$a005.26/8$$223
000764335 08204 $$a004
000764335 1001_ $$aMorgado, Flavio.
000764335 24510 $$aProgramming Excel with VBA :$$ba Practical Real-World Guide.
000764335 260__ $$aBerkeley, CA :$$bApress,$$c2016.
000764335 300__ $$a1 online resource (802 pages)
000764335 336__ $$atext$$btxt$$2rdacontent
000764335 337__ $$acomputer$$bc$$2rdamedia
000764335 338__ $$aonline resource$$bcr$$2rdacarrier
000764335 5050_ $$aAt 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.
000764335 5058_ $$aUsing 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.
000764335 5058_ $$aVBA 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.
000764335 5058_ $$aDealing 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.
000764335 5058_ $$aUsing 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.
000764335 5058_ $$aUsing the VBA DoEvents Instruction.
000764335 506__ $$aAccess limited to authorized users.
000764335 588__ $$aDescription based on print version record.
000764335 63000 $$aMicrosoft Excel (Computer file)
000764335 650_0 $$aVisual Basic for Applications (Computer program language)
000764335 77608 $$iPrint version:$$aMorgado, Flavio.$$tProgramming Excel with VBA : A Practical Real-World Guide.$$dBerkeley, CA : Apress, ©2016$$z9781484222041
000764335 852__ $$bebk
000764335 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-2205-8$$zOnline Access$$91397441.1
000764335 909CO $$ooai:library.usi.edu:764335$$pGLOBAL_SET
000764335 980__ $$aEBOOK
000764335 980__ $$aBIB
000764335 982__ $$aEbook
000764335 983__ $$aOnline
000764335 994__ $$a92$$bISE