# Solutions

## Articles, examples, tutorials, and references for Solutions:

…software program[s] that extends the capabilities of larger programs. For example, there are many Excel add-ins designed to complement the basic functionality offered by Excel.

# Forms

## What are Forms?

Forms, or in Excel-speak, UserForms, are a way of providing a graphical user interface with text fields, labels, buttons, checkboxes, and many other elements rather than an intimidating spreadsheet consisting of cells and formula bars. Userforms are the way you present applications to the end user, by limiting the types of input and how their input is processed. There are elements that can be activated right on the spreadsheet, the most popular being a button, but creating a UserForm as a user interface to a spreadsheet requires some knowledge of VBA (Visual Basic for Applications). All the Microsoft Office products have some type of UserForm and VBA, however there are some differences between products. This section is dedicated to articles, examples, tutorials, and products that will help you get a better understanding of Forms and UserForms.

# Formulas and Functions

## Formulas and Functions. What’s the difference?

There are many definitions of Formulas and Functions available on the web. The most succinct and understandable comes from the About.com Guide, the definition of Formula:

Formulas in spreadsheet programs such as Excel are used to perform calculations. Formulas can range from basic mathematical operations – such as addition and subtraction – to complex engineering and statistical calculations. In programs such as Excel, Open Office Calc, and Google Docs Spreadsheets, formulas begin with an equal ( = ) sign and, for the most part, they are entered into to the worksheet cell(s) where we want the results or answer to appear.

And the definition of Function from About.com:

A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed by the function’s name and its arguments. The function name tells Excel what calculation to perform. The arguments are contained inside round brackets. For example, the most used function in Excel is the SUM function, which is used to add together the data in selected cells. The SUM function is written as –

= SUM ( D1 : D6 )Here the function adds the contents of cell range D1 to D6 and displays the answer in cell D7.

This section is dedicated to articles, examples, tutorials, and references that specifically address Formulas and Functions in Excel.

# Welcome to Excel VBA Wizard!

## Welcome to Excel VBA Wizard! -The place to find Excel VBA Tips and Techniques

Excel is the most popular and widely used spreadsheet in the world. It is unfortunate that many people only utilize a fraction of its capabilities. Everybody who has ever looked at the Help files knows that the lists of formulas, functions, and features used in the spreadsheet are daunting. Excel VBA Wizard hopes to give you some insights, examples, and pointers.

Excel, along with other Microsoft products, contain a complete programming language called VBA, which stands for Visual Basic Applications.  Each of the Microsoft VBA implementations, for example Word, Powerpoint, Visio, Outlook, etc. have slight variations and different libraries. Excel VBA Wizard is dedicated to both native Excel functions from a spreadsheet user perspective, but also Tips and Techniques as they relate to Excel Macros and VBA Programming.

While I have a good deal of experience both as a spreadsheet user and VBA programmer, I want to introduce you to others who are MUCH BETTER at this than I am.  The goal is to create and grow a community that can share, and contribute so that others can benefit from your experience.

My thanks, as always, to the Microsoft Excel MVP’s who have been a tremendous resource and inspiration. My HEROES.  