Search TeachExcel

New Excel Help Service!

We need your input to help create a new Live Online Excel Help service.

Please take our survey and let us know your thoughts!

Excel Survey

Have a great day!

Don


Featured Excel Content

Activate or Navigate to a Worksheet using Macros VBA in Excel
Excel Tip
Make a particular worksheet visible using a macro in Excel. This is called activating a worksheet and is rather easy to do. Sections: Activate Worksheet by Name Activate Worksheet by Index Number Notes Activate Worksheet by Name Let's navigate to, activate, the worksheet called "Sheet2". Worksheets("Sheet2").Activate Worksheets("Shee2") is how we r ...
View Excel Tip
 
Run a Macro when a User Does Something in the Worksheet in Excel
Excel Tip
How to run a macro when a user does something in the worksheet, everything from selecting a cell, to editing a cell, to changing the worksheet. You can set a macro to run in many different situations based on what the user does. There are two different kinds of events that we can use to initiate macros, here, I will cover events that are worksheet ...
View Excel Tip
 
Variables in Macros VBA for Excel - Practical Guide
Excel Tip
This is a practical guide to using Variables in Macros and VBA for Excel. I will tell you what they are and how to use them. Sections: What is a Variable? Why Should I use Variables? How to Make and Use Variables in Macros Naming Variables Declaring Variables - What is it and Are you Sure It's Not Important? Notes What is a Variable? A variable is ...
View Excel Tip
 
Select Data from Separate Worksheets with Macros VBA in Excel
Excel Tip
Select data from other worksheets with Macros and VBA without navigating to those worksheets or activating them. This method allows the user to remain on one single worksheet while the macro goes through the workbook to get data from where it needs to get it. Syntax Worksheets(Sheet name or Index number) Argument Description Sheet name or Index num ...
View Excel Tip
 
Get User Submitted Data from a Prompt in Excel using VBA Macros
Excel Tip
How to prompt a user for their input in Excel. There is a simple way to do this using VBA and macros; we use the InputBox function. This causes a small window to appear that has a place for the user to enter data. In this tutorial I will show you examples of how to get a user's input using this method; this is a practical tutorial, which means that ...
View Excel Tip
 
Put Data into a Worksheet using a Macro in Excel
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 ...
View Excel Tip
 
Get Data from the Worksheet into a Macro in Excel
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 data ...
View Excel Tip
 
What is a Macro in Excel?
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 ...
View Excel Tip
 
Excel VBA MsgBox - Message Box Macro
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 ...
View Excel Tip
 
VBA Comparison Operators
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 B ...
View Excel Tip
 
Excel Forum