VBA inventory - stock program

[georgie23]

Dear all,

I am very new to VBA and I would like to learn how to create an inventory manager

I have found a ready made program which is almost perfect however I would like to add a couple of more things in such as Bin location, category etc

Please find the file attached

http://www.webandmacros.net/excel-macro-stocks-management.htm

Thank you
G

 

[royUK]

You cannot modufy that workbook because the project is locked.

 

[dmt32]

Hi,
Changes you want should be able to be done but the VBA code in the application is password protected - you will need to contact the the author of the application with your requirements.

Hope Helpful

Dave

 

[georgie23]

I see. Is it possible to explain roughly how to make a similar program ?

It does not seem that complicated however I dont know where to start

 

[dmt32]

I see. Is it possible to explain roughly how to make a similar program ?

It does not seem that complicated however I dont know where to start

Hi,
If application you found more or less is doing what you want would be worth your while contacting the author. Probably find more than happy to help you.

If want to start from scratch have a look here:http://www.contextures.com/excelfiles.html

& from the list, look for file:UF0017 - Parts Database with Updateable Comboboxes

You can download for free & view the code which may be of some help to getting you started.

Dave

 

[royUK]

I have a free database form that you can download from here

 

[georgie23]

thank you