To insert a new VBA code module in Excel’s Visual Basic Editor, first open the Visual Basic Editor…
Then click View > Project Explorer…
Right-click VBAProject and click Insert > Module…
A new, numbered module appears, waiting for your VBA code…
How to insert a VBA code Module in Excel’s Visual Basic Editor