Share via

Excel for Mac - VBA module names

Anonymous
2017-02-04T09:56:15+00:00

How can I change the name of a VBA module in Excel for Mac (v15.30) to make it more meaningful, rather than just Module 1 or Module 2?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-02-04T14:50:23+00:00

    Hi RodH999,

    To change the name of a VBA module in Excel for Mac, please follow the steps below: 

    1. Go to VBAProject > Modules. 
    2. Right click on Module1 or Module 2. 
    3. Select Rename and change the module name. 

    Regards,

    Shirley

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2017-02-04T13:38:12+00:00

    Right-click on the module name on the left pane and choose Rename... type a new name.

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-04-13T15:11:26+00:00

    Another way:  control-click is the same as right0click.

    0 comments