Microsoft Excel Tutorials, Help, Forum, and more

Search TeachExcel

Featured Excel Content

Macro to get Data from Another Workbook in Excel

Macro to get data from a workbook, closed or open, over a network or locally on your computer. This is a versatile and self-contained macro that opens another workbook, gets information from it, and then closes that other workbook. This happens so fast that you won't even notice what is happening; it should feel seamless. (This technique will also ...

View Excel Tip

Comments in Macros in Excel

How to put comments into a macro so that it's easier to understand and maintain them. Comments allow you to make notes within your macro and VBA code. These notes do not affect the execution of the macro at all and, when the macro is run, Excel pretends that the comments aren't even there. Sections: How to Make Comments in Macros When should you Us ...

View Excel Tip

Input Form to Get Data and Store it in Another Tab in Excel

How to make a user input form in Excel and have the data stored on another worksheet at the click of a button. This method uses a simple-to-create input form that anyone can make and maintain within the worksheet and does not cover UserForms that are made in VBA and that can be quite tricky for users to create and maintain. This tutorial does use a ...

View Excel Tip

Macro to Open a Website from Excel

How to open a website in the browser from Excel using a Macro and VBA. This is the same as following a link or clicking a link from the worksheet except that it will be done through a Macro. This does not open a website within Excel. Everything will still open in the browser. The Macro Here is the full macro that you need: Sub Go_to_Website() Dim i ...

View Excel Tip

Activate or Navigate to a Worksheet using Macros VBA in Excel

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

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

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

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

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

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

Search TeachExcel

New Excel Help Service!

Featured Excel Content