How to add a module

Simple way is to start recording a macro, choose to save it in the relevant workbook, then just stop recording.

Alternatively, open the VB Editor (Alt+f11) then right click the workbook in the Project Explorer window (usually top left) and choose Insert - Module

Quote

Simple way is to start recording a macro, choose to save it in the relevant workbook, then just stop recording.

That was how I started.