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…

Learn to create web automation bots with Excel & VBA
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…