Search TeachExcel

What is a UserForm?
Description: Give a thorough explanation of a UserForm in Excel; this should at least include what it is; what it can do; and give a couple examples of userforms. Please include a sample file if possible.

Latest Forum Questions

Nov 20, '17 at 3:06 am
Answers: 1
Nov 22, '17 at 9:08 am
Answers: 0
Nov 21, '17 at 1:31 pm
Answers: 0
Nov 20, '17 at 6:25 pm
Answers: 0
Nov 20, '17 at 1:15 am
Answers: 1
Nov 20, '17 at 3:13 am
Answers: 1
Nov 20, '17 at 3:15 am
Answers: 1

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


Excel Tip
This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when you hit Ctrl+P on your keyboard or when you select Print from the file or Office Button menu. This is a great macro to use when you don't want to give users access to keyboard shortcuts or Excel menus because you can set this macr ...
 
Excel Tip
This Excel macro removes all filtering from a worksheet in Excel. This allows you to completely remove any filter now matter how complex from any worksheet in Excel. This means that the entire original data set will then be visible in Excel. How Filter Macros Work All of the elements below often appear within autofilter macros. Range This should be ...
 
Excel Tip
Hide comments in Excel with this macro. Comment indicators will still appear in the cells and users will also be able to view the comments when hovering over a cell that contains a comment. This macro serves as a way to put comments back to their default behavior in Excel and is great to use when you have a lot of comments set to permanently show ...
 
Excel Tip
This free excel macro allows you to print the entire workbook in Excel. You can easily set this macro to a button within the spreadsheet and allow users to more easily print the entire workbook or Excel file. Where to install the macro:  Module Print Entire Workbook in Excel Macro Sub Print_Current_Workbook() 'Prints the current active workbo ...
 
Excel Tip
This macro will allow you to specify certain criteria and then to delete rows based upon that criteria. You will choose the Row, Column, and Sheet where you want to delete the rows; then you will select what you want to look for to delete a row - you type in keywords, which, if present in a cell, will cause that row to be deleted. This is a little ...
 
Excel Tip
This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within the workbook, it will be printed. This macro will print the charts on separate pages so that each chart will be on its own page. Where to install the macro:  Module Print all Embedded Charts in the Workbook Sub PrintEmbedde ...
 
Excel Tip
This free Excel macro allows you to apply filter settings to a data set, list, or range of data in Excel. This will not actually filter the data but it will put the filter "arrows" into the header row of the data set. This lets people know that the data set is ready to be filtered and makes it easier to filter the data when needed. If you already h ...
 
Excel Tip
This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will delete every row with an identical cell which is underneath the first occurrence. The first instance will still remain, but all identical cells in the rows underneath the original cell will be deleted. In order to run the macro, you ne ...
 
Excel Tip
This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and worksheet. When the macro runs, it prompts you to select which excel files from your computer you would like to combine and, once you select them and press ok, this macro will pull data from pre-specified worksheets in the selected workb ...
 
Excel Tip
This UDF (user defined function) calculates the Future Value of Compound Interest in Excel. The mathematical formula that is behind this function is PV * (1 + r) ^ N. This is a great function to include in your workbook if you often work with financial calculations such as the future value of invested sums of money or other assets. This adds funct ...
 
Excel Forum