|
Learn the hard core of Excel the easy way, by example:
Excel is not just a spread sheet to store data. It also has Visual Basic
within it that can be used to create powerful applications. Although Excel does not have the full version of Visual
Basic, their is enough Visual Basic capabilities to create some
useful applications. An application could be of any type you would create to
perform some function desired. This Excel workbook explains
by example how to use the
following Visual Basic options within Excel:
- dialog boxes
- forms
- edit boxes
- pull down menus
- option buttons
- check boxes
- scroll bars
- spinners
- command buttons
- how to write code Visual Basic
Advantage(s):
The biggest advantage will be that your data base, report
functions, and application is stored in one file.
If you have been using Excel, you do not need to pay for expensive-advance
Excel classes. This file will give you the basics, shown by example, how you can use Visual Basic in your Excel applications.
Explanations and examples are given on how to use the graphical capability and Visual Basic code within Excel so you can develop
applications on your own. You will only have one file to
maintain and the that file will be small.
Limitation(s):
Your imagination is the only limitation.
|