Email:      Pass:    Pass?

Site Information and Updates

Update and Discussion #5

Don here,

Lots of exciting features have been completed for the Excel forum; read the blog post and make sure to give me any feedback you have. :)

posted: May 25, 2016

Read More

Featured Excel Content



Excel Tip
How to input data into cells in a worksheet from a macro. Once you have data in your macro and you do something with it, you need to be able to put it back into Excel so you can see it or store it. This tutorial assumes that you have read and are familiar with the last tutorial: Get Data from the Worksheet into a Macro in Excel Sections: Putting Da ...
Added: May 25, 2016
 
Excel Tip
Here, you'll learn how to get information from the Excel worksheet into a macro so you can do something with it. One of the most important things with macros is getting information from the user, and the most often used method is to get it from a cell in the worksheet. There are two steps required to do this: reference a cell that contains the dat ...
Added: May 24, 2016
 
Excel Tip
This is the first step to learning about Macros for Excel and how to use them. What is a Macro?   A macro is a small program that you make in Excel that automates tasks. Basically, this "thing", the macro, can save you hours of time. You can create macros that do almost anything in Excel and even other Microsoft Office programs. How can Macros Help ...
Added: May 23, 2016
 
Excel Tip
Create a pop-up message box in Excel using VBA Macros. This allows you to show a message to the user and to get input back, depending on which buttons were clicked in the pop-up message. To output a message in Excel, we use the MsgBox function. Below, you will find many examples that should suit your needs. Sections: Syntax Example 1 - Output Basic ...
Added: May 18, 2016
 
Excel Tip
VBA comparison operators are used to compare values in VBA and Macros for Excel. List of VBA Comparison Operators Comparison Operator Meaning < A < B - Checks if A is LESS THAN B. > A > B - Checks if A is GREATER THAN B. <= A <= B - Checks if A is less than or equal to B. >= A >= B - Checks if A is greater than or equal to ...
Added: May 17, 2016
 
Excel Tip
How to create a countdown timer in Excel. This allows you to display a timer in whatever cell you want and it will count down until it reaches zero. I also included a method to stop or pause the timer. To create the countdown timer, a macro will be used. However, this tutorial does not require any previous knowledge of macros or VBA in Excel. If yo ...
Added: May 11, 2016
 
Excel Tip
Excel function that makes combining text very easy. This function is simpler and better than the CONCATENATE function. This function is a UDF and this tutorial assumes that you have a basic understanding of those. You can learn about them here: User Defined Functions (UDF) in Excel Sections: Syntax Create the Function and Install It Usage Examples ...
Added: May 9, 2016
 
Excel Tip
Excel function that makes it easy to extract a word or text from a cell in Excel. This is a single function! It does NOT require a complex formula or nested functions or anything like that. To use this function, we first need to create it using a UDF, User Defined Function. You can learn about this kind of function here: User Defined Functions in E ...
Added: May 3, 2016
 
Excel Tip
This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods to insert a check-mark into Excel, including using Macros/VBA and a UDF, or User Defined Function. Sections: Basic Method to Insert a Check Mark into Excel VBA Method to Insert a Check Mark into Excel UDF that Inserts a Check Mark into Excel Notes Basic Metho ...
Added: May 2, 2016
 
Excel Tip
How to loop through a range of cells in a UDF, User Defined Function, in Excel. This is almost the same as doing it for a basic macro, but getting the input is different. If you don't know what a UDF is, view this tutorial to learn more: Custom Functions in Excel - UDF Sections: Loop through a Range of Cells in a UDF Working Function Final Code No ...
Added: Apr 27, 2016
 
Subscribe for Free Excel tips & more!
E-mail: