View Single Post
 
Old 04-24-2018, 08:05 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.


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
File Type: jpg Inventory.jpg (90.5 KB, 32 views)
Attached Files
File Type: xlsm Inventory.xlsm (21.2 KB, 9 views)
Reply With Quote