I never knew how to start and name a new project in Excel VBA. Will someone explain how to?
Thank you for your response.
I never knew how to start and name a new project in Excel VBA. Will someone explain how to?
Thank you for your response.
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.
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)
Re: Start Vba Project
Thank you Will and Fencliff.
Don’t have an account yet? Register yourself now and be a part of our community!