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! I promise I won't bite. :)

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

Don

Requested Tutorials

What is a UserForm?
Status: approved
view details
Simple Alternatives to UserForms
Status: approved
view details
How to Create a UserForm
Status: approved
view details
Adding Controls to a UserForm
Status: approved
view details
Showing a UserForm
Status: approved
view details
Closing a UserForm
Status: approved
view details
UserForm Properties
Status: approved
view details
UserForm Control Properties
Status: approved
view details
Getting Data from a UserForm
Status: approved
view details
Putting Data into a UserForm
Status: requested
view details
Setting Default Values for Controls in UserForms
Status: requested
view details
Clearing All Values in a UserForm
Status: requested
view details
Use Macros within UserForms
Status: requested
view details
UserForm Events
Status: requested
view details
UserForm Controls Events
Status: requested
view details
Changing the Appearance of a UserForm
Status: requested
view details
Modeless UserForm
Status: requested
view details
Creating a Splash Screen in Excel
Status: requested
view details
Multi-Page UserForm
Status: requested
view details
Scrollable UserForm
Status: requested
view details
Resizable UserForm
Status: requested
view details
Removing the Title Bar from a UserForm
Status: requested
view details
Transparent UserForm
Status: requested
view details
Loop Through the Controls in a UserForm
Status: requested
view details
Select Ranges in the Worksheet from a UserForm
Status: requested
view details
Dependent ComboBox Drop Down Menus
Status: requested
view details
Multi-Column ComboBox Drop Down Menu
Status: requested
view details
Allowing Multiple Selections in a ListBox
Status: requested
view details
Getting Data from a ListBox Control
Status: requested
view details
Moving Items between ListBox Controls
Status: requested
view details
Disabling Buttons in UserForms
Status: requested
view details
Progress Indicator
Status: requested
view details
Data Input Template
Status: requested
view details
Employee Information Template
Status: requested
view details
Product Information Template
Status: requested
view details
CheckBox - UserForm Control
Status: requested
view details
ComboBox - UserForm Control
Status: requested
view details
CommandButton - UserForm Control
Status: requested
view details
Frame - UserForm Control
Status: requested
view details
Image - UserForm Control
Status: requested
view details
Label - UserForm Control
Status: requested
view details
ListBox - UserForm Control
Status: requested
view details
MultiPage - UserForm Control
Status: requested
view details
OptionButton - UserForm Control
Status: requested
view details
RefEdit - UserForm Control
Status: requested
view details
ScrollBar - UserForm Control
Status: requested
view details
SpinButton - UserForm Control
Status: requested
view details
TabStrip - UserForm Control
Status: requested
view details
TextBox - UserForm Control
Status: requested
view details
ToggleButton - UserForm Control
Status: requested
view details

Latest Forum Posts

Dec 14, '17 at 5:42 pm
Answers: 1
Dec 14, '17 at 1:10 pm
Answers: 1
Dec 13, '17 at 11:08 am
Answers: 1
Dec 12, '17 at 2:53 am
Answers: 1
Dec 13, '17 at 6:12 am
Answers: 1
Dec 12, '17 at 6:58 am
Answers: 1
Dec 12, '17 at 3:29 pm
Answers: 1

Featured Excel Content


Excel Tip
This is a macro which will delete blank rows in excel. This version will delete an entire row if there is a blank cell detected in the column which you select. This works by having a message box pop up in excel and then asking you how many rows, below and including the cell you selected, you want to check for and delete if it contains an empty cell ...
 
Excel Tip
Free Excel UDF that displays the name of the Excel workbook without its extension. This is a great UDF (user defined function) to use when you want to display the name of your workbook but don't want to have to also display the workbook file extension .xls .xlsm etc. This UDF is simple to use as it requires no arguments or user-supplied data; just ...
 
Excel Tip
This macro will change the formulas in cells to absolute or relative. It allows you to change the rows or the columns or both to absolute or relative references. This macro works on a selection of cells. This means that you can select only the cells you want to change and then run the macro on them. Alternatively, you can not select a cell with a f ...
 
Excel Tip
This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 pages from a 10 page workbook or file or 4 pages from that workbook etc. The macro allows you to choose which pages you want to print by inputting the number for the from and to argument. The from argument is the page number from whic ...
 
Excel Tip
Excel macro that will delete all of the comment contained within the active or current worksheet in Excel. This macro deletes only the in-cell comments in Excel. This is a great way to quickly and effectively clean up your Excel worksheets. This saves you the hassle of deleting comments by hand and is very useful for people who make a lot of notes ...
 
Excel Tip
This macro will delete columns which are completely empty. This means that if there is no data within the entire column it will be removed. This macro works on a selection of cells within the excel spreadsheet. That means that you must select cells and then run the macro for it to do anything.Note: The first macro will work for Excel 2007 whereas t ...
 
Excel Tip
Add comments to cells in Excel with this macro. This allows you to quickly and easily add a comment to any cell within a worksheet or workbook in Excel. In order to use this macro simply replace the A1 cell reference with the range object with the cell that you want to add a comment to and also replace the text This is my comment. with the text tha ...
 
Excel Tip
This free Excel UDF allows you to output the color of a cell in text format or as that color's index number. Also note that this refers to the fill color of a cell. For instance, if you point the function to a cell that is red, the function will ouput "Red" or the index number "3." The range argument for this function just points to the cell that h ...
 
Excel Tip
This macro will highlight all cells in excel which are not empty. This means that if a cell contains formulas, text, numbers, or other characters it will be filled in with color, or highlighted. The first macro listed will work on the entire active sheet which you are on. The second macro will be limited to a predefined or specified range in the wo ...
 
Excel Tip
This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of rows, run the macro, and then will delete only rows that have no data. This is a great macro if you receive data that has only some empty cells but the columns next to the empty cells are still important. Where to install the macro:  Modu ...
 
Excel Forum