View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lonnie M. Lonnie M. is offline
external usenet poster
 
Posts: 184
Default Simple Inventory Control Programs in Excel

Hi,
The first step is planning it. Determine your input, processing, and
output variables.
Input variables--Those that the user inputs.
Processing variables--Those that are used for calculations.
Output variables--The results that are displayed or placed somewhere.
It is not uncommon for variables to be in more than one category.

The next step in planning is writing an algorithm for each process you
wish to incorporate into your application. This is simply writing a
step by step process of how you will do each process. This will help
you develop the logic and order behind the process.

After this I recommend that you record a macro and perform each step
that you planned out in your above algorithm for that process.

When a specific question then arises, there is a great deal of
information in the help menu's and posts within this news group, if you
get stuck there is a number of people here who will gladly help you in
your development.

Good Luck! Lonnie M.