Sir,
Why in the world do you want to use Visual Basic For Applications for the software need? We will be using C# based Windows desktop application with an Microsoft Access database to save data!
We have done many Inventory applications and this should be easy job.. Please respond to us so that we can send screenshots of our work!
Thanks,
Arsalan