Power Spreadsheets

Excel VBA Sheets and Worksheets: Step-by-Step Guide and 16 Examples to Refer to Sheets or Worksheets in Macros

In this VBA Tutorial, you learn how to refer to, and work with, sheets and worksheets in macros. This includes: How to refer to all sheets in a workbook. How to refer to all worksheets in a workbook. How to refer to the active sheet. How to refer to a sheet by its index number. How to refer to a worksheet by its index number. How to refer to a sheet by its name. … [Read more...]

Excel Power Query (Get & Transform) Tutorial for Beginners: Import, Edit, Load and Consolidate Data with this Step-By-Step Guide

In this Power Query (Get & Transform) Tutorial for beginners, you learn how to use Power Query (Get & Transform) to automate the process of importing and consolidating data in Excel. The following are the main topics you learn about: What Power Query is and how it can help you. What data sources can Power Query import data from. How to import data from 3 … [Read more...]

Excel VBA InputBox: Step-by-Step Guide and 9 Examples to Create an Input Box with Macros

In this VBA Tutorial, you learn how to create input boxes with both the InputBox function and the Application.InputBox method. This includes: How to create an InputBox. How to create an InputBox with multiple lines. How to create an InputBox that works with a specific type of data. How to handle the cases where the user clicks the Cancel button of the InputBox. This VBA … [Read more...]

Excel VBA MsgBox: Step-by-Step Guide and 19 Examples to Create a Message Box with Macros

In this VBA Tutorial, you learn how to create message boxes and specify their most important characteristics, such as the following: How to specify the message displayed in the message box. How to customize or specify the buttons displayed by the message box. How to work with the value returned by the MsgBox function, and assign this value to a variable. How to specify the … [Read more...]

Excel VBA Value and Value2: Step-by-Step Guide and 8 Examples to Set or Get a Cell’s or Cell Range’s Value with Macros

In this VBA Tutorial, you learn how to set a cell's or cell range's value and get a cell's or cell range's value. This VBA Tutorial is accompanied by Excel workbooks containing the macros and data I use in the examples below. You can get immediate access to these example workbooks by subscribing to the Power Spreadsheets Newsletter. Use the following Table of Contents … [Read more...]