How to insert a VBA code Module in Excel’s Visual Basic Editor

To insert a new VBA code module in Excel’s Visual Basic Editor, first open the Visual Basic Editor

Excel - click Visual Basic
Excel – click Visual Basic

Then click View > Project Explorer

VBE - click View, Project Explorer
VBE – click View, Project Explorer

Right-click VBAProject and click Insert > Module

VBE - click Insert, Module
VBE – click Insert, Module

A new, numbered module appears, waiting for your VBA code…

VBA - new Module1 created and waiting for VBA code
VBA – new Module1 created and waiting for VBA code
Facebooktwittergoogle_plusredditlinkedintumblrFacebooktwittergoogle_plusredditlinkedintumblr