@ Jett and Paul,

Only Standard Modules can't use the same Names, because they are all compiled as a single "DLL." The purpose of Standard Modules is to make Programmers' jobs easier by providing a way to better organize their code.

Class Modules can use the same Procedure names, because Class Modules are only visible to external code as Instantiated Objects.

ThisWorkbook and Worksheet Code pages can also use the same Procedure names, because they are Instantiated Class Modules and their Code Pages are really addendums to their Class code. The ThisWorkbook Code Page is that particular Workbook's Class "Addendum."

UserForms are also Classes and multiple Forms can use the same names

You can see all of any Class Objects Properties, Methods, Events, and, Public Variables and Constants by pressing F2 while viewing that Code Page