Share via

VBA- No tab for insert (procedure and function)

Anonymous
2016-05-09T15:23:01+00:00

When running vba the window appears but there is no additional tab to insert procedures. I am in the process of updating el captain. Will this fix the problem?

Microsoft 365 and Office | Excel | For home | MacOS

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-05-11T16:01:12+00:00

    In this version of the VB Editor, once you add a module you have to type everything yourself.

    Recording a macro will give you something to work with.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2016-05-09T16:26:26+00:00

    Thank you, are you able to show me how to add functions and subs?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-05-09T15:52:38+00:00

    In the editor, right-click on an object in the left panel to insert modules. Set references by clicking the little wheel in the lower left corner.

    Was this answer helpful?

    0 comments