Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a user friendly inventory system using Excel as b.
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 -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User-friendly lookup solutions needed | Excel Discussion (Misc queries) | |||
I need a user friendly route sheet! Help! :} | New Users to Excel | |||
Looking for a production schedule excel/access & user friendly? | Setting up and Configuration of Excel | |||
How can I set up an inventory control system on Excel? | Excel Discussion (Misc queries) | |||
user friendly filter | Excel Programming |