Excel VBA UserForm Lessons

10 Lessons and 5 Workbook examples on Excel VBA UserForms

Description of Excel VBA UserForm Lessons:

Lesson 2 has Time Saving Microsoft Excel Solutions. It is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions.

No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!

BASIC COURSE OUTLINE:

UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops, Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, Some Useful Methods and Functions, When to apply Validation, Control Events, Which Controls to use and When, Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or False, Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime.

WHY USE US FOR EXCEL TRAINING?

Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers i65.00

See Also: All products from OzGrid Business Applications

1. Real Option Valuation 1.0
   The Real Option Valuation model by Excel Business Tools
2. Excel Level 2 Lessons
   10 Lessons and 5 Workbook examples on Excel level 2
3. OM-LEARN
   Excel Spreadsheet Template for Learning curves data.
4. ExcelPipe
   ExcelPipe is used by IT personnel to repair hyperlinks when a server gets renamed, by SMEs and large organisations when they change their contact details/name/etc, by translators to apply massive search/replace lists - the list of uses is endless.
5. XLTradeLink
   An Excel addin to link data from a variety of data sources
6. Complete Excel Course
   Excel Levels 1, 2, 3 VBA and UserForms Courses
7. Conditional Format Assistant for Microsoft Excel
   The Conditional Format Assistant is designed to help you format cells based on hundreds of different conditional tests. You can specify value ranges, greater than, less than and many other tests. You can have as many tests as you want.
8. Excel Compare, Corporate License (1000 computers)
   Excel Compare is a tool that saves you the trouble of manual search for differences and offers you computer-aided comparing of Excel files. Excel Compare is a tool that allows you to compare Excel files, Excel spreadsheets and selected ranges of sheets.
9. Cascade Chart Creator
   Create cascade charts quickly and easily. Cascade charts are a unique and very useful way to explain change from one time period to another.
10. Excel Level 1, 2 and 3 Training
    Excel levels Basic to Advanced Training
11. To Do List Assistant for Microsoft Excel
    Manage your to do lists within Microsoft Excel!
12. Growing Money - for Windows 95 or higher
    Growmony.EXE - You may be overwhelmed by this time-value of money invested analysis.
13. TorniaiSansUT LightItalic PC
    TorniaiSansUT LightItalic PC
14. TorniaiSansUT Family PC
    TorniaiSansUT Family PC
15. OM-FACILITY LOCATION
    Excel Spreadsheet Templates for locating distribution center.
16. OM-FORECASTING
    Excel Spreadsheet Templates for Forecasting.
17. TorniaiSansUT RegularItalic PC
    TorniaiSansUT RegularItalic PC
18. Excel Typos Finder 1.4
    Aren't you sick and tired of typos? It is a specially designed tool to help you polish off all typos in your Excel workbook. Introduce a new order in your data!
19. Variable Rate Mortgage - for Windows 3.1
    Varimtge.exe - You can use this program to either investigate or track a variable-rate mortgage or to project the payout of this type mortgage.
20. Added Payment Amortization - for Windows 3.1
    Addedpmt.EXE - A program illustrating the effect of additional payments for reducing interest paid and the term of a loan.