MsgBox in Excel VBA (Easy Message Boxes)
The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 16/22
October 8, 2024
Calculated Field/Item in a Pivot Table
This example teaches you how to insert a calculated field or calculated item in a pivot table in Excel.
ActiveX Controls in Excel VBA
Learn how to create ActiveX controls such as command buttons text boxes list boxes etc. To create an ActiveX control in Excel VBA execute the following steps.
How to Alphabetize in Excel
This tutorial will guide you through the process of alphabetizing in Excel. While sorting data alphabetically in Excel is easy certain situations may require more advanced techniques to achieve the desired alphabetical order.
Count with Or Criteria - Excel Formulas
Counting with Or criteria in Excel can be tricky. This article shows several easy to follow examples.
How to use the Excel AGGREGATE function
Excel functions such as SUM COUNT LARGE and MAX don't work if a range includes errors. However you can easily use the AGGREGATE function to fix this.
Create a Pattern in Excel VBA
Below we will look at a program in Excel VBA that creates a pattern.
User Defined Function in Excel VBA
Below we will look at a program in Excel VBA that creates a User Defined Function. Excel has a large collection of functions. In most situations those functions are sufficient to get the job done. If not you can create your own function called User Defined Function or custom Excel function. You can access a User Defined Function just like any other Excel function.
MsgBox Function in Excel VBA (Easy Yes/No Message Box)
The MsgBox function in Excel VBA can return a result while a simple MsgBox cannot.
Subscript Out of Range in Excel VBA
The 'subscript out of range' error in Excel VBA occurs when you refer to a nonexistent collection member or a nonexistent array element.
Find Circular References in Excel
A circular reference in Excel occurs when a formula directly or indirectly refers to its own cell. This is not possible. Let's start simple.
Flash Fill in Excel
Flash fill is a great Excel tool. Learn how to use flash fill to automatically extract data combine data and much more.
Gauge Chart in Excel
A gauge chart (or speedometer chart) combines a Doughnut chart and a Pie chart in a single chart. If you are in a hurry simply download the Excel file.
Volatile Functions in Excel VBA
By default UDF's (User Defined Functions) in Excel VBA are not volatile. They are only recalculated when any of the function's arguments change. A volatile function will be recalculated whenever calculation occurs in any cells on the worksheet. Let's take a look at an easy example to explain this a bit more.
Close and Open Workbooks in Excel VBA
The Close and Open Method in Excel VBA can be used to close and open workbooks. Remember the Workbooks collection contains all the Workbook objects that are currently open.
Import/Export Text Files - Excel Tutorial
This article describes how to import or export text files in Excel. Text files can be comma separated (.csv) or tab separated (.txt)
How to use XLOOKUP in Excel
If you have Excel 365 or Excel 2021 use XLOOKUP instead of VLOOKUP. The XLOOKUP function is easier to use and has some additional advantages.
Formula Auditing in Excel
Formula auditing in Excel allows you to display the relationship between formulas and cells. The example below helps you master Formula Auditing quickly and easily.
Turn off Scroll Lock in Excel
When Scroll Lock is turned on you can use the arrow keys to scroll through the worksheet without changing the active cell. Excel displays Scroll Lock in the status bar.
Split Worksheet in Excel
You can split your Excel worksheet into panes to view multiple distant parts of your worksheet at once. Simply use the split bar to change the size of each pane.
Highlight Active Cell in Excel VBA
Below we will look at a program in Excel VBA that highlights the row and column of the Active Cell (selected cell). This program will amaze and impress your boss.
Advanced Filter in Excel
This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria.
Make a Read-only Workbook in Excel
This example shows you how to make your Excel workbook read-only. Users without a password can still save changes by creating a new copy of the workbook.
Default Templates in Excel
Book.xltx and Sheet.xltx are two special templates you can create and add to the XLStart folder. As a result Excel uses Book.xltx as the basis for new workbooks and Sheet.xltx as the basis for new worksheets.