Search TeachExcel

Free Excel Training!

Help me create the best free Excel training experience on the web!

Today, I launch the Requested Tutorials feature that you can see below. Using this feature, I want to work with you to create the content that you want.

We start-off with a brand new course for UserForms in Excel. The goal is to create an expectional training guide for building UserForms in Excel so that you never have to pay to learn this material.

View the UserForms course outline in this blog post and feel free to leave your feedback there.

I need your help to create the content, and I look forward to working with you in a collaborative manner in order to create an extensive, open, and free learning experience for everyone!

Sign-in to your account today and submit a tutorial! :)

(Blog post about our future and how we want to work with you to create the best possible learning experience.)

Don

Latest Forum Posts

Aug 15, '19 at 12:19 pm
Answers: 1
Aug 11, '19 at 9:58 am
Answers: 1
Aug 14, '19 at 12:29 pm
Answers: 1
Aug 9, '19 at 5:27 pm
Answers: 1
Aug 9, '19 at 12:48 pm
Answers: 1
Aug 5, '19 at 2:14 pm
Answers: 2

Our YouTube Channel is Back!

Over 250 Video Tutorials and Counting!
  • Updated every week!
  • Step-by-step tutorials.
  • Excel workbooks included for all new tutorials.

Featured Excel Content


Excel Tip
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 ...
 
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 ...
 
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 ...
 
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 ...
 
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 ...
 
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 ...
 
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 ...
 
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 ...
 
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 ...
 
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 ...
 
Excel Forum