An Excel VBA Macro Enabled file used to add or search any sanitary product that is mentioned in a separate sheet.
Made for in-house use
It contains a file named .
This macro has 3 UserForms and 5 Modules.
- AddOrSearch_Ufm :
- AddProduct_Ufm :
- Search_Ufm :
- Update_Mod.bas : It contains subroutines that update ComboBox in above mentioned forms with the data given in
Data
worksheet. - GenerateCode_Mod.bas : It has function which is used to generate a unique code according to the product specifications that are mentioned by user with the help of data given in
Data
worksheet.. - AddProduct_Mod.bas : It contains two functions for Adding Product to
Products
worksheet and for Searching Product fromProducts
worksheet. - fitAndFormat_Mod.bas : It contains a function that auto-fit all cells in the worksheet and change the formatting of the first row as specified.