hiskio

    Excel VBA Notes for Professionals book

    Amazing collection of free programming books

    收集中
    免费
    Amazing collection of free programming books

    The Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

    Book created for educational purposes and is not affiliated with group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

    https://goalkicker.com/

    章节目录

    1-1Content list
    1-2About
    1-3Chapter 1: Getting started with Excel VBA
    1-4Section 1.1: Opening the Visual Basic Editor (VBE)
    1-5Section 1.2: Declaring Variables
    1-6Section 1.3: Adding a new Object Library Reference
    1-7Section 1.4: Hello World
    1-8Section 1.5: Getting Started with the Excel Object Model
    1-9Chapter 2: Arrays
    1-10Section 2.1: Dynamic Arrays (Array Resizing and Dynamic Handling)
    1-11Section 2.2: Populating arrays (adding values)
    1-12Section 2.3: Jagged Arrays (Arrays of Arrays)
    1-13Section 2.4: Check if Array is Initialized (If it contains elements or not)
    1-14Section 2.5: Dynamic Arrays [Array Declaration, Resizing]
    1-15Chapter 3: Conditional statements
    1-16Section 3.1: The If statement
    1-17Chapter 4: Ranges and Cells
    1-18Section 4.1: Ways to refer to a single cell
    1-19Section 4.2: Creating a Range
    1-20Section 4.3: Oset Property
    1-21Section 4.4: Saving a reference to a cell in a variable
    1-22Section 4.5: How to Transpose Ranges (Horizontal to Vertical & vice versa)
    1-23Chapter 5: Named Ranges
    1-24Section 5.1: Define A Named Range
    1-25Section 5.2: Using Named Ranges in VBA
    1-26Section 5.3: Manage Named Range(s) using Name Manager
    1-27Section 5.4: Named Range Arrays
    1-28Chapter 6: Merged Cells / Ranges
    1-29Section 6.1: Think twice before using Merged Cells/Ranges
    1-30Chapter 7: Locating duplicate values in a range
    1-31Section 7.1: Find duplicates in a range
    1-32Chapter 8: User Defined Functions (UDFs)
    1-33Section 8.1: Allow full column references without penalty
    1-34Section 8.2: Count Unique values in Range
    1-35Section 8.3: UDF - Hello World
    1-36Chapter 9: Conditional formatting using VBA
    1-37Section 9.1: FormatConditions.Add
    1-38Section 9.2: Remove conditional format
    1-39Section 9.3: FormatConditions.AddUniqueValues
    1-40Section 9.4: FormatConditions.AddTop10
    1-41Section 9.5: FormatConditions.AddAboveAverage
    1-42Section 9.6: FormatConditions.AddIconSetCondition
    1-43Chapter 10: Workbooks
    1-44Section 10.1: When To Use ActiveWorkbook and ThisWorkbook
    1-45Section 10.2: Changing The Default Number of Worksheets In A New Workbook
    1-46Section 10.3: Application Workbooks
    1-47Section 10.4: Opening A (New) Workbook, Even If It's Already Open
    1-48Section 10.5: Saving A Workbook Without Asking The User
    1-49Chapter 11: Working with Excel Tables in VBA
    1-50Section 11.1: Instantiating a ListObject
    1-51Section 11.2: Working with ListRows / ListColumns
    1-52Section 11.3: Converting an Excel Table to a normal range
    1-53Chapter 12: Loop through all Sheets in Active Workbook
    1-54Section 12.1: Retrieve all Worksheets Names in Active Workbook
    1-55Section 12.2: Loop Through all Sheets in all Files in a Folder
    1-56Chapter 13: Use Worksheet object and not Sheet object
    1-57Section 13.1: Print the name of the first object
    1-58Chapter 14: Methods for Finding the Last Used Row or Column in a Worksheet
    1-59Section 14.1: Find the Last Non-Empty Cell in a Column
    1-60Section 14.2: Find the Last Non-Empty Row in Worksheet
    1-61Section 14.3: Find the Last Non-Empty Column in Worksheet
    1-62Section 14.4: Find the Last Non-Empty Cell in a Row
    1-63Section 14.5: Get the row of the last cell in a range
    1-64Section 14.6: Find Last Row Using Named Range
    1-65Section 14.7: Last cell in Range.CurrentRegion
    1-66Section 14.8: Find the Last Non-Empty Cell in Worksheet - Performance (Array)
    1-67Chapter 15: Creating a drop-down menu in the Active Worksheet with a Combo Box
    1-68Section 15.1: Example 2: Options Not Included
    1-69Section 15.2: Jimi Hendrix Menu
    1-70Chapter 16: File System Object
    1-71Section 16.1: File, folder, drive exists
    1-72Section 16.2: Basic file operations
    1-73Section 16.3: Basic folder operations
    1-74Section 16.4: Other operations
    1-75Chapter 17: Pivot Tables
    1-76Section 17.1: Adding Fields to a Pivot Table
    1-77Section 17.2: Creating a Pivot Table
    1-78Section 17.3: Pivot Table Ranges
    1-79Section 17.4: Formatting the Pivot Table Data
    1-80Chapter 18: Binding
    1-81Section 18.1: Early Binding vs Late Binding
    1-82Chapter 19: autofilter ; Uses and best practices
    1-83Section 19.1: Smartfilter!
    1-84Chapter 20: Application object
    1-85Section 20.1: Simple Application Object example: Display Excel and VBE Version
    1-86Section 20.2: Simple Application Object example: Minimize the Excel window
    1-87Chapter 21: Charts and Charting
    1-88Section 21.1: Creating a Chart with Ranges and a Fixed Name
    1-89Section 21.2: Creating an empty Chart
    1-90Section 21.3: Create a Chart by Modifying the SERIES formula
    1-91Section 21.4: Arranging Charts into a Grid
    1-92Chapter 22: CustomDocumentProperties in practice
    1-93Section 22.1: Organizing new invoice numbers
    1-94Chapter 23: PowerPoint Integration Through VBA
    1-95Section 23.1: The Basics: Launching PowerPoint from VBA
    1-96Chapter 24: How to record a Macro
    1-97Section 24.1: How to record a Macro
    1-98Chapter 25: SQL in Excel VBA - Best Practices
    1-99Section 25.1: How to use ADODB.Connection in VBA?
    1-100Chapter 26: Excel-VBA Optimization
    1-101Section 26.1: Optimizing Error Search by Extended Debugging
    1-102Section 26.2: Disabling Worksheet Updating
    1-103Section 26.3: Row Deletion - Performance
    1-104Section 26.4: Disabling All Excel Functionality Before executing large macros
    1-105Section 26.5: Checking time of execution
    1-106Section 26.6: Using With blocks
    1-107Chapter 27: VBA Security
    1-108Section 27.1: Password Protect your VBA
    1-109Chapter 28: Debugging and Troubleshooting
    1-110Section 28.1: Immediate Window
    1-111Section 28.2: Use Timer to Find Bottlenecks in Performance
    1-112Section 28.3: Debugger Locals Window
    1-113Section 28.4: Debug.Print
    1-114Section 28.5: Stop
    1-115Section 28.6: Adding a Breakpoint to your code
    1-116Chapter 29: VBA Best Practices
    1-117Section 29.1: ALWAYS Use "Option Explicit"
    1-118Section 29.2: Work with Arrays, Not With Ranges
    1-119Section 29.3: Switch o properties during macro execution
    1-120Section 29.4: Use VB constants when available
    1-121Section 29.5: Avoid using SELECT or ACTIVATE
    1-122Section 29.6: Always define and set references to all Workbooks and Sheets
    1-123Section 29.7: Use descriptive variable naming
    1-124Section 29.8: Document Your Work
    1-125Section 29.9: Error Handling
    1-126Section 29.10: Never Assume The Worksheet
    1-127Section 29.11: Avoid re-purposing the names of Properties or Methods as your variables
    1-128Section 29.12: Avoid using ActiveCell or ActiveSheet in Excel
    1-129Section 29.13: WorksheetFunction object executes faster than a UDF equivalent
    1-130Chapter 30: Excel VBA Tips and Tricks
    1-131Section 30.1: Using xlVeryHidden Sheets
    1-132Section 30.2: Using Strings with Delimiters in Place of Dynamic Arrays
    1-133Section 30.3: Worksheet .Name, .Index or .CodeName
    1-134Section 30.4: Double Click Event for Excel Shapes
    1-135Section 30.5: Open File Dialog - Multiple Files
    1-136Chapter 31: Common Mistakes
    1-137Section 31.1: Qualifying References
    1-138Section 31.2: Deleting rows or columns in a loop
    1-139Section 31.3: ActiveWorkbook vs. ThisWorkbook
    1-140Section 31.4: Single Document Interface Versus Multiple Document Interfaces
    1-141Credits
    1-142You may also like

    常见问答

    您可以透過手機、平板或是電腦登入 HiSKIO 平台，在【我的學習】＞【我的書籍】頁面，選擇想看的電子書。

    猜你喜欢

    用户评价

    | 收集中

    销售方案