Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Start Vba Project

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Start Vba Project

    I never knew how to start and name a new project in Excel VBA. Will someone explain how to?

    Thank you for your response.

  • #2
    Re: Starting A Vba Project

    When you create a new workbook in Excel, it automatically contains a VBA project. Each workbook can only have one.

    You can rename the project in the Project Explorer window by right-clicking the project (top-level node saying "VBAProject (Workbook name)") you want to rename and click VBA Project Properties... and assign a new name in the Project Name field.

    Simple as that.

    Comment


    • #3
      Re: Starting A Vba Project

      A VBA project is automatically created when you create a new workbook.

      To view it, open the visual basic editor - It is named the same as your workbook

      VBAProject (YourFileName.xls)
      Kind Regards, Will Riley

      LinkedIn: Will Riley

      Comment


      • #4
        Re: Start Vba Project

        Thank you Will and Fencliff.

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X