In this article you will learn how to open Microsoft visual basic for applications window in Excel. You will be starting to learn or use VBA, that’s why you are reading this article. Best of luck… you have decided to explore a big ocean.
Before coming into the point let’s discuss the uses of VBA
Use of Microsoft Visual Basic for Applications
Using Visual basic for applications (VBA) we can program excel tasks, by writing custom codes. We can program a series of tasks in Excel and this program can be run in just one click.
This application will help to complete task easily and faster. And this is the basics of excel automation.
No need to have coding skill, for using entry level VBA.
There is a function to record macro in Excel.
You can learn how to record macro and automate tasks in Excel from this article.
Am I deviating from subject….?
How to open VBA window in excel
See how Factovare helps factories digitize work
Watch the demo and contact us to try Factovare for your manufacturing operations.
FCMEP Three-Month Programme Registration
Factovare Certified Manufacturing Excellence Professional (FCMEP)
Trainer: Founder of Factovare and Know Industrial Engineering
Learn directly from the person behind both platforms.
Foundation session
Any one Tuesday · 1 hour
Trainer: Founder of Know Industrial Engineering and Factovare.
Doubt clearance
Alternate Thursdays · 09:00 PM IST · 1 hour
Trainer: Founder of Know Industrial Engineering and Factovare. Attend every eligible session during your active period.
Self-learning access
Three months of guided practice
Use selected Factovare modules and protected training materials to learn and practise throughout the programme.
You may attend any one Tuesday foundation session. Your three-month programme starts on the date you attend your first foundation session. From that date, you can self-learn using the training materials and eligible Factovare modules, and attend all eligible alternate-Thursday doubt-clearance sessions.
What you will learn
Enter your details, verify your email and complete the one-time $29 USD payment to join the three-month programme.
Step 1: Enter your name and email address, then click Send OTP.
Here we will discuss two method to open Microsoft VBA in Excel.
Method 1
- Open excel file
- Press Alt key in keyboard and press F11 key in keyboard without releasing Alt key.
That’s it….a window will pop up and that’s the window for VBA.
Method 2
- Open excel file
- Click on Developer tap (if not able to see developer, tab click here)
- Click on Visual Basic
A window will pop up and that’s VBA window.
Now you are ready to dive in to a big ocean of VBA.
Thank you.
Now or Never
We’ve got your back on your manufacturing journey — Stay in touch
Follow us for step-by-step guidance, templates, and insights that save time and reduce mistakes.
Know Industrial Engineering Platform – Helping manufacturing industry professionals worldwide since 2019
