Our Excel Courses

Latest Forum Posts

copy to bottom under header based on match combobox on userf
Aug 18, '22 at 7:23 am
Answers: 1
Filter Data as you type - TABLE
Jun 3, '21 at 2:24 pm
Answers: 2
populate last value into textbox based on combobox
Aug 18, '22 at 5:45 am
Answers: 1
Filtering and delete hyphen(-) to set as blank
Aug 18, '22 at 4:25 am
Answers: 0
Highlight Column A and B only
Aug 17, '22 at 6:29 pm
Answers: 1
Form controls behaving erratically
Aug 17, '22 at 1:18 pm
Answers: 0
function UCASE doesn't work with small letters
Aug 15, '22 at 4:06 am
Answers: 1

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


Featured Excel Content

Comments in Macros in Excel
Excel Tip
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
Excel Tip
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
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 ...
View Excel Tip
 
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