عنوان
پدید آورنده
موضوع
رده
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
1118991370
(Number (ISBN
1118991400
(Number (ISBN
1118991419
(Number (ISBN
9781118991374
(Number (ISBN
9781118991404
(Number (ISBN
9781118991411
NATIONAL BIBLIOGRAPHY NUMBER
Number
b418497
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
Excel VBA :
General Material Designation
[Book]
Other Title Information
24-hour trainer /
First Statement of Responsibility
Tom Urtis.
EDITION STATEMENT
Edition Statement
Second edition.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
1 online resource.
GENERAL NOTES
Text of Note
"Programmer to programmer"--Page [4] of cover.
Text of Note
Includes index.
CONTENTS NOTE
Text of Note
Cover; Title Page; Copyright; Contents; Part I: Understanding the BASICs; Lesson 1: Introducing VBA; What Is VBA?; A Brief History of VBA; What VBA Can Do for You; Automating a Recurring Task; Automating a Repetitive Task; Running a Macro Automatically if Another Action Takes Place; Creating Your Own Worksheet Functions; Simplifying the Workbook's Look and Feel for Other Users; Controlling Other Office Applications from Excel; Liabilities of VBA; Try It; Lesson 2: Getting Started with Macros; Composing Your First Macro; Accessing the VBA Environment; Using the Macro Recorder; Running a Macro.
Text of Note
Lesson RequirementsHints; Step-by-Step; Lesson 9: Making Decisions with VBA; Understanding Logical Operators; AND; OR; NOT; Choosing Between This or That; If ... Then; If ... Then ... Else; If ... Then ... ElseIf; IIF; Select Case; Getting Users to Make Decisions; Message Boxes; Input Boxes; Try It; Lesson Requirements; Hints; Step-by-Step; Part III: Beyond the Macro Recorder: Writing Your Own Code; Lesson 10: Repeating Actions with Loops; What Is a Loop?; Types of Loops; Do ... While; Do ... Until; Do ... Loop While; Do ... Loop Until; While ... Wend; Nesting Loops; Try It; Lesson Requirements; Hints; Step-by-Step.
Text of Note
Step-by-StepPart II: Diving Deeper into VBA; Lesson 5: Object-Oriented Programming: An Overview; What "Object-Oriented Programming" Means; The Object Model; Properties; Methods; Collections; Try It; Lesson 6: Variables, Data Types, and Constants; What Is a Variable?; Assigning Values to Variables; Why You Need Variables; Data Types; Understanding the Different Data Types; Declaring a Variable for Dates and Times; Declaring a Variable with the Proper Data Type; Forcing Variable Declaration; Understanding a Variable's Scope; Local Macro Level Only; Module Level; Application Level; Constants.
Text of Note
The Macro Dialog BoxShortcut Key; Try It; Lesson Requirements; Hints; Step-by-Step; Lesson 3: Introducing the Visual Basic Editor; What Is the VBE?; How to Get Into the VBE; Understanding the VBE; Understanding Modules; Using the Object Browser; Exiting the VBE; Try It; Lesson 4: Working in the VBE; Toolbars in the VBE; Macros and Modules; Locating Your Macros; Understanding the Code; Editing a Macro with Comments and Improvements to the Code; Deleting a Macro; Inserting a Module; Renaming a Module; Deleting a Module; Locking and Protecting the VBE; Try It; Lesson Requirements; Hints.
Text of Note
Try ItLesson Requirements; Step-by-Step; Lesson 7: Understanding Objects and Collections; Workbooks; Cells and Ranges; SpecialCells; Try It; Lesson Requirements; Step-by-Step; Lesson 8: Working with Ranges; Working with Contiguously Populated Ranges; Using the Cells Property; Using CurrentRegion; Working with Noncontiguously Populated Ranges; Using Range with Several Cells; Using OFFSET; Using RESIZE; Identifying a Data Range; Identifying the UsedRange; Finding the Dynamic Last Rows and Columns; Identifying Where the Range Starts and Ends When No Start or End Point Is Known; Try It.
0
8
8
8
8
SUMMARY OR ABSTRACT
Text of Note
Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined wit.
ACQUISITION INFORMATION NOTE
Source for Acquisition/Subscription Address
Safari Books Online
Stock Number
CL0500000600
PARALLEL TITLE PROPER
Parallel Title
Excel Visual Basic Applications : twenty-four hour trainer.
TITLE USED AS SUBJECT
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
TOPICAL NAME USED AS SUBJECT
Business-- Computer programs.
Electronic spreadsheets.
Business-- Computer programs.
Electronic spreadsheets.
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
(SUBJECT CATEGORY (Provisional
COM-- 054000
PERSONAL NAME - PRIMARY RESPONSIBILITY
Urtis, Tom
ORIGINATING SOURCE
Date of Transaction
20150915111851.0
Cataloguing Rules (Descriptive Conventions))
pn
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
