View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M. Hall M. Hall is offline
external usenet poster
 
Posts: 1
Default How do I set up a user friendly inventory system using Excel as b.

Excel 2000 (maybe Excell 2003 in near future): The Excel environment is a bit
intimidating to the casual user. I know little to nothing about VBA, but I am
assuming I can set up forms using VBA for inventory control. Inventory
received (in), sold (out), monthly physical count, etc. Instead of having a
user become familiar with Excel cells and environment and data entry in same,
I would rather use user input forms using Excel in the background as data
retrieval and storage.

If this is possible, what I would REALLY like is some similar inventory
example that I could learn and pull knowledge together and set up my own
system.