How to Change Excel VBA Module Name


To change the excel vba module name, from the tools menu go to Macro,

Choose Tools and go to Macros in the menu

From the dropdown select visual basic editor.

Select Visual Basic Editor (VBA)

Then select the module under the VBAProject which houses your filename.

Choose your VBA project

Right Click and select VBA Project Properties.

Right click and select VBA Project Properties

In Properties window, change the name as desired.

Change the name as desired

Changes will be saved when you click outside the box or click OK.

Click OK or anywhere outside the box

You’ve now now changed the Excel VBA module name.

VBA module name is now successfully changed