How do I set up a user friendly inventory system using Excel as b.

[M. Hall]

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.

 

[Guest]

i know of no sites that are specificly dedecated to
inventory control but here are some sites that deal with
user forms in general. that might get you started. post
again if you have specific problems.
http://j-walk.com/ss/excel/tips/tip84.htm
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
http://www.dicks-
blog.com/excel/2004/09/linking_userfor.html
http://support.microsoft.com/?id=213749
http://support.microsoft.com/?id=161514
http://msdn.microsoft.com/library/en-
us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
http://msdn.microsoft.com/library/en-
us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp
http://support.microsoft.com/default.aspx?scid=kb;en-
us;829070
good luck