Excel VBA programming for dummies
Take control of your spreadsheets and use VBA to create your own custom Excel applications Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet soluti...
Uloženo v:
| Hlavní autor: | |
|---|---|
| Médium: | E-kniha Kniha |
| Jazyk: | angličtina |
| Vydáno: |
Hoboken, N.J
Wiley
2013
John Wiley & Sons, Incorporated For Dummies |
| Vydání: | 3 |
| Témata: | |
| ISBN: | 1118490371, 9781118490372 |
| On-line přístup: | Získat plný text |
| Tagy: |
Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
|
| Abstract | Take control of your spreadsheets and use VBA to create your own custom Excel applications Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more. Introduces you to a wide array of new Excel 2013 options, beginning with the most important tools and operations for the Visual Basic Editor Provides an overview of the essential elements and concepts for programming with Excel, including using VBA to customize your applications and automate functions Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more Zeroes in on creating custom dialog boxes, toolbars, and menus Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition. |
|---|---|
| AbstractList | Take control of your spreadsheets and use VBA to create your own custom Excel applications Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more. Introduces you to a wide array of new Excel 2013 options, beginning with the most important tools and operations for the Visual Basic Editor Provides an overview of the essential elements and concepts for programming with Excel, including using VBA to customize your applications and automate functions Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more Zeroes in on creating custom dialog boxes, toolbars, and menus Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition. John Walkenbach gets readers acquainted with the most important tools and operations for the Visual Basic editor. He also provides an overview of the essential elements and concepts for programming with Excel. Discover techniques for handling errors and exterminating bugs, the basics of working with range objects, and much more. |
| Author | Walkenbach, John |
| Author_xml | – sequence: 1 fullname: Walkenbach, John |
| BackLink | https://cir.nii.ac.jp/crid/1130282272386157184$$DView record in CiNii |
| BookMark | eNo9kFtLA0EMhUe0Ylv7H1YQxIfCZK6Zx7bUCxR8kb4u09lsXbvd1Z1W-_MdrZqH5AQ-DicZsLOmbeiEjZxFAEDluER3ygZ_i4UeGwgOwmmjQJ6zPgoUzkmFF2wU4ytP5bhxqPrsan4IVGfL6SR769p157fbqllnZdtlxT5pipesV_o60uh3Dtnybv48exgvnu4fZ5PF2GvNjRzb0shVkAV5w20IhSXUQpDgniNq0BBKHlI65Ugq40HIFVll0AYsbVFwOWS3R2MfN_QZX9p6F_OPmlZtu4n5_7VglUrszZFNod_3FHf5Dxao2XW-zufTGYBQKuUasusj2VRVHqrvDiB5-oiwQqIBbZOr_AL7PVqF |
| ContentType | eBook Book |
| DBID | RYH |
| DEWEY | 005.54 |
| DatabaseName | CiNii Complete |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Business Computer Science |
| DocumentTitleAlternate | Microsoft Excel VBA programming for dummies |
| EISBN | 9781118490389 111849038X 1118491742 9781118491744 |
| Edition | 3 3rd Edition |
| ExternalDocumentID | 9781118491744 EBC1124406 BB13240052 |
| GroupedDBID | 089 20A 38. 5VX A4J AABBV AALIM ABARN ABQPQ ACLGV ACNAM ADNEN ADVEM AERYV AHWGJ AJFER ALMA_UNASSIGNED_HOLDINGS AMYDA AUKZS AZZ BBABE BPBUR CZZ HF4 IVN JJU MYL NK1 NK2 OHILO OODEK PQQKQ RYH UZ6 6XM DRU IVK IWL WZT |
| ID | FETCH-LOGICAL-a55063-7f63bc3dea607ccd7e8522e20a0885151cf0c03749e346a123be74687c8f7dd03 |
| ISBN | 1118490371 9781118490372 |
| IngestDate | Fri Nov 08 04:10:59 EST 2024 Wed Dec 10 13:21:11 EST 2025 Thu Jun 26 21:59:45 EDT 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCN | 2012956413 |
| LCCallNum_Ident | HF5548.4.M523.W35 2013 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a55063-7f63bc3dea607ccd7e8522e20a0885151cf0c03749e346a123be74687c8f7dd03 |
| Notes | Includes index |
| OCLC | 828299348 |
| PQID | EBC1124406 |
| PageCount | 411 |
| ParticipantIDs | askewsholts_vlebooks_9781118491744 proquest_ebookcentral_EBC1124406 nii_cinii_1130282272386157184 |
| PublicationCentury | 2000 |
| PublicationDate | c2013 2013 2013-01-31 |
| PublicationDateYYYYMMDD | 2013-01-01 2013-01-31 |
| PublicationDate_xml | – year: 2013 text: c2013 |
| PublicationDecade | 2010 |
| PublicationPlace | Hoboken, N.J |
| PublicationPlace_xml | – name: Hoboken, N.J – name: Somerset |
| PublicationYear | 2013 |
| Publisher | Wiley John Wiley & Sons, Incorporated For Dummies |
| Publisher_xml | – name: Wiley – name: John Wiley & Sons, Incorporated – name: For Dummies |
| SSID | ssj0000906984 ssib013448846 |
| Score | 1.9881338 |
| Snippet | Take control of your spreadsheets and use VBA to create your own custom Excel applications Author and Excel guru John Walkenbach, known to his devoted fans as... John Walkenbach gets readers acquainted with the most important tools and operations for the Visual Basic editor. He also provides an overview of the essential... |
| SourceID | askewsholts proquest nii |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | Business -- Computer programs Computer software Computer software -- Development Electronic spreadsheets Microsoft Excel (Computer file) Microsoft Visual Basic for applications |
| TableOfContents | Turning off automatic calculation -- Eliminating those pesky alert messages -- Simplifying object references -- Declaring variable types -- Using the With-End With structure -- Part IV: Communicating with Your Users -- Chapter 15: Simple Dialog Boxes -- UserForm Alternatives -- The MsgBox Function -- Displaying a simple message box -- Getting a response from a message box -- Customizing message boxes -- The InputBox Function -- InputBox syntax -- An InputBox example -- Another type of InputBox -- The GetOpenFilename Method -- The syntax for the GetOpenFilename method -- A GetOpenFilename example -- The GetSaveAsFilename Method -- Getting a Folder Name -- Displaying Excel's Built-in Dialog Boxes -- Chapter 16: UserForm Basics -- Knowing When to Use a UserForm -- Creating UserForms: An Overview -- Working with UserForms -- Inserting a new UserForm -- Adding controls to a UserForm -- Changing properties for a UserForm control -- Viewing the UserForm Code window -- Displaying a UserForm -- Using information from a UserForm -- A UserForm Example -- Creating the UserForm -- Adding the CommandButtons -- Adding the OptionButtons -- Adding event-handler procedures -- Creating a macro to display the dialog box -- Making the macro available -- Testing the macro -- Chapter 17: Using UserForm Controls -- Getting Started with Dialog Box Controls -- Adding controls -- Introducing control properties -- Dialog Box Controls: The Details -- CheckBox control -- ComboBox control -- CommandButton control -- Frame control -- Image control -- Label control -- ListBox control -- MultiPage control -- OptionButton control -- RefEdit control -- ScrollBar control -- SpinButton control -- TabStrip control -- TextBox control -- ToggleButton control -- Working with Dialog Box Controls -- Moving and resizing controls -- Aligning and spacing controls -- Accommodating keyboard users Entering code directly -- Using the macro recorder -- Copying VBA code -- Customizing the VBA Environment -- Using the Editor tab -- Using the Editor Format tab -- Using the General tab -- Using the Docking tab -- Chapter 4: Introducing the Excel Object Model -- Excel Is an Object? -- Climbing the Object Hierarchy -- Wrapping Your Mind around Collections -- Referring to Objects -- Navigating through the hierarchy -- Simplifying object references -- Diving into Object Properties and Methods -- Object properties -- Object methods -- Object events -- Finding Out More -- Using VBA's Help system -- Using the Object Browser -- Automatically listing properties and methods -- Chapter 5: VBA Sub and Function Procedures -- Subs versus Functions -- Looking at Sub procedures -- Looking at Function procedures -- Naming Subs and Functions -- Executing Sub procedures -- Executing the Sub procedure directly -- Executing the procedure from the Macro dialog box -- Executing a macro by using a shortcut key -- Executing the procedure from a button or shape -- Executing the procedure from another procedure -- Executing Function procedures -- Calling the function from a Sub procedure -- Calling a function from a worksheet formula -- Chapter 6: Using the Excel Macro Recorder -- Is It Live, or Is It VBA? -- Recording Basics -- Preparing to Record -- Relative or Absolute? -- Recording in absolute mode -- Recording in relative mode -- What Gets Recorded? -- Recording Options -- Macro name -- Shortcut key -- Store Macro In -- Description -- Is This Thing Efficient? -- Part III: Programming Concepts -- Chapter 7: Essential VBA Language Elements -- Using Comments in Your VBA Code -- Using Variables, Constants, and Data Types -- Understanding variables -- What are VBA's data types? -- Declaring and scoping variables -- Working with constants -- Pre-made constants Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- Is This the Right Book? -- So You Want to Be a Programmer -- Why Bother? -- What I Assume about You -- Obligatory Typographical Conventions Section -- Check Your Security Settings -- How This Book Is Organized -- Part I: Getting Started with Excel VBA Programming -- Part II: How VBA Works with Excel -- Part III: Programming Concepts -- Part IV: Communicating with Your Users -- Part V: Putting It All Together -- Part VI: The Part of Tens -- Icons Used in This Book. -- Getting the Sample Files -- Now What? -- Part I: Getting Started with Excel VBA Programming -- Chapter 1: What Is VBA? -- Okay, So What Is VBA? -- What Can You Do with VBA?. -- Inserting a bunch of text -- Automating a task you perform frequently -- Automating repetitive operations -- Creating a custom command -- Creating a custom button -- Developing new worksheet functions -- Creating custom add-ins for Excel -- Creating complete, macro-driven applications -- Advantages and Disadvantages of VBA -- VBA advantages -- VBA disadvantages -- VBA in a Nutshell -- An Excursion into Versions -- Chapter 2: Jumping Right In -- First Things First -- What You'll Be Doing -- Taking the First Steps -- Recording the Macro -- Testing the Macro -- Examining the Macro -- Modifying the Macro -- Saving Workbooks That Contain Macros -- Understanding Macro Security -- More about the NameAndTime Macro -- Part II: How VBA Works with Excel -- Chapter 3: Working in the Visual Basic Editor -- What Is the Visual Basic Editor? -- Activating the VBE -- Understanding VBE components -- Working with the Project Window -- Adding a new VBA module -- Removing a VBA module -- Exporting and importing objects -- Working with a Code Window -- Minimizing and maximizing windows -- Creating a module -- Getting VBA code into a module Testing a UserForm Activate and deactivate events in a sheet -- Activate and deactivate events in a workbook -- Workbook activation events -- Other Worksheet-Related Events -- The BeforeDoubleClick event -- The BeforeRightClick event -- The Change event -- Events Not Associated with Objects -- The OnTime event -- Keypress events -- Chapter 12: Error-Handling Techniques -- Types of Errors -- An Erroneous Example -- The macro's not quite perfect -- The macro is still not perfect -- Is the macro perfect yet? -- Giving up on perfection -- Handling Errors Another Way -- Revisiting the EnterSquareRoot procedure -- About the On Error statement -- Handling Errors: The Details -- Resuming after an error -- Error handling in a nutshell -- Knowing when to ignore errors -- Identifying specific errors -- An Intentional Error -- Chapter 13: Bug Extermination Techniques -- Species of Bugs -- Identifying Bugs -- Debugging Techniques -- Examining your code -- Using the MsgBox function -- Inserting Debug.Print statements -- Using the VBA debugger -- About the Debugger -- Setting breakpoints in your code -- Using the Watch window -- Using the Locals window -- Bug Reduction Tips -- Chapter 14: VBA Programming Examples -- Working with Ranges -- Copying a range -- Copying a variable-sized range -- Selecting to the end of a row or column -- Selecting a row or column -- Moving a range -- Looping through a range efficiently -- Looping through a range efficiently (Part II) -- Prompting for a cell value -- Determining the selection type -- Identifying a multiple selection -- Changing Excel Settings -- Changing Boolean settings -- Changing non-Boolean settings -- Working with Charts -- AddChart versus AddChart2 -- Modifying the chart type -- Looping through the ChartObjects collection -- Modifying chart properties -- Applying chart formatting -- VBA Speed Tips -- Turning off screen updating Working with strings -- Working with dates -- Using Assignment Statements -- Assignment statement examples -- About that equal sign -- Smooth operators -- Working with Arrays -- Declaring arrays -- Multidimensional arrays -- Dynamic arrays -- Using Labels -- Chapter 8: Working with Range Objects -- A Quick Review -- Other Ways to Refer to a Range -- The Cells property -- The Offset property -- Some Useful Range Object Properties -- The Value property -- The Text property -- The Count property -- The Column and Row properties -- The Address property -- The HasFormula property -- The Font property -- The Interior property -- The Formula property -- The NumberFormat property -- Some Useful Range Object Methods -- The Select method -- The Copy and Paste methods -- The Clear method -- The Delete method -- Chapter 9: Using VBA and Worksheet Functions -- What Is a Function? -- Using Built-In VBA Functions -- VBA function examples -- VBA functions that do more than return a value -- Discovering VBA functions -- Using Worksheet Functions in VBA -- Worksheet function examples -- Entering worksheet functions -- More about using worksheet functions -- Using Custom Functions -- Chapter 10: Controlling Program Flow and Making Decisions -- Going with the Flow, Dude -- The GoTo Statement -- Decisions, Decisions -- The If-Then structure -- The Select Case structure -- Knocking Your Code for a Loop -- For-Next loops -- Do-While loop -- Do-Until loop -- Using For Each-Next Loops With Collections -- Chapter 11: Automatic Procedures and Events -- Preparing for the Big Event -- Are events useful? -- Programming event-handler procedures -- Where Does the VBA Code Go? -- Writing an Event-Handler Procedure -- Introductory Examples -- The Open event for a workbook -- The BeforeClose event for a workbook -- The BeforeSave event for a workbook -- Examples of Activation Events |
| Title | Excel VBA programming for dummies |
| URI | https://cir.nii.ac.jp/crid/1130282272386157184 https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=1124406 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781118491744 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3dS8MwEI9zirgnP3HqpIpvUkjbNB-P25gIyhCcc_hSkjSDsVllm2N_vpeurdt8EB98CW1Kr-SO3u8uuQ-ErhUXMjC-cokXhy6hmrhKwe_OPBUSgBSt07y17gNrt3mvJx5LG0meCzMbsSTh87n4-FdRwxwI26bO_kHcBVGYgGsQOowgdhjXLOLiNg-n02Z0023U86CrtzxKMobPLwULvsjR0CRKLrpAFcG4me9v-zCs-P6p4lhxCEFzcSJwsGiHs1ZJutHwbPk9HAJkbTIKrupW_fn-9anYk8ICU8FJ2lApo-NlZbEKuhVUkZMhKGBQztMJIHIyGPzAsRScO3uobBM29lHJJAdoJ4_kP0SXKUMcYIizxBAHGOJkDDlC3dtWp3nnZh0hXAmeFA1c1qeB0kFsJMVM65gZDgak8bEEbQmmmaf7WNuSOsIEhEqAZWUYoZxp3mdxjINjVE7eE3OCHKF8oYQyQuo-4ZoqSrgKeRyaMGDSp1V0tbTQaDZKT68nUcEN8OVIFdVg_ZEe2NGzh8BgcNk-bmAoAurDcyfnTJS-n4XcRq1G07OmFaanv5A4Q7vfoj9H5en409TQtp5NB5PxRSbCLxiPA4M |
| linkProvider | ProQuest Ebooks |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.title=Excel+VBA+programming+for+dummies&rft.au=Walkenbach%2C+John&rft.date=2013-01-01&rft.pub=Wiley&rft.isbn=9781118490372&rft.externalDocID=BB13240052 |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97811184%2F9781118491744.jpg |