.


When you get into the VBE you should see the layout as in the image below. Here is a download link if you cant see it : https://www.amazon.com/clouddrive/sh...DAWtCF7b01zg98

The treeview on the left side will let you access the Sheet Level Modules and the Routine Modules (if any have been added to a project). There are always Sheet Level modules, even if they are not utilized.

If the treeview is not fully expanded, you can click on the small plus [+] symbols on the left side to do so.

Double clicking on the word MODULE1 will open the right side screen to the code used
in your project.

It is common practice on the Excel forums to not only provide the formula or code that is needed to answer a question but oftentimes to include the sample project with the actual code. That way the questioner has the added bonus of seeing where the code was pasted.

Hope this helps.

Attached Images

Inventory.jpg (90.5 KB, 32 views)

Attached Files

Inventory.xlsm (21.2 KB, 9 views)