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. Anonymous
    2017-02-06T01:23:59+00:00

    Hi RodH999,

    We haven’t heard from you for a while. Could you let me know any updates at your convenience?

    Regards,

    Shirley

    0 comments
  2. Anonymous
    2017-04-12T16:42:31+00:00

    There is no right click on a MAC

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-04-13T01:14:21+00:00

    Well.... Technically there is. Go To: 

    1. The  menu  → System Preference  → TrackPad, go through all the Gestures.
    2. There is one where if you click with two fingers, it act like Control-Click (which is Right Click).
    3. If you have an Apple Mighty Mouse or any USB or BlueTooth mouse you can also set up an actual right-click.

    _________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.

    0 comments