Skip to main content

Alt+F11 Excel Shortcut To Open Visual Basic Editor To Create Macro | ExcelTip2Day

Hello everyone.

I'm Michael. Welcome you all to my blog "Exceltip2day". I'm going to talk about what and how to use an Excel shortcut key as this highlight as follows:

"ALT" + "F11" keyboard shortcut to open a visual basic editor.


Tip Quiz

What is the shortcut to reverse the screen upside down?


Do you use Excel for your daily work?

I'm Michael Leng, I work for a company in Thailand. In my working office, we usually use Excel to handle our tasks.

Therefore, I would like to share with you all through my blog the simple tips about Excel.

In Excel Version 2010, There are, as far as I know, 2 ways to display the "Visual Basic Editor" box for the next proceeding the task in Excel program.

The first choice is recommended. Because it is very quick and easy. The shortcut is as follows:
  • Press the "Alt" button and keep hold it down
  • Then also press the "F11" together at the same time

Keyboard shortcut:  To open the Visual Basic Editor to create Macros.
bb

Windows shortcut 



ALTF11

Then, the "VBA" box is going to come out instantly as the image is shown below.


Shortcut key to call out a Visual Basic Editor using for creating macro in an Excel spreadsheet
The figure shows the "VBA" box

Secondly, pertaining to the "VBA" is commonly located within the "Developer" ribbon tab.

Moreover, the Developer tab does design for displaying for instantly use.

Hence, we have to bring it out first-then we would see the "VBA" for application later on.

Find on the "How To" below:

  • Seek the File tab on the left of Excel Workbook, there, choose the "Options" beneath the "Help"
  • Once the Options dialog box is shown, clicking "Customize Ribbon" on the left side of the dialog box which is under the "Advance", but upper the "Quick Access Toolbar".
  • Selecting the "Popular Commands" under the "Choose Commands From" which is on the left of the dialog box.
  • Under the "Customize The Ribbon" on the top far right side of the dialog box, select the "Main Tabs", then selecting the "Developer" checkbox which it is in a large square box.
  • Clicking the "OK" button at the down below right side of the "Main Tabs" box.
  • Then the "Developer Tab" will display on the ribbon that it usually locates next to the "View" ribbon.

That's all the both Excel operations for Pop Out the Visual Basic Editor for Application.

At this stage, besides the "VBA" you can also just select the Macros, Record Macro, Macro Security,... Buttons on the tab.

So, now you know how to access the VBA(Visual basic editor) already. As I have shared with you the ways how to reach it as above.

I really hope that this my today's article about fixing and performing an Excel office by yourself would help rescue you from any trouble in Excel more or less.

This weblog is designed by the writer in order to help you, the Excel office user, to know how to solve and or operate it in your home.

Why do I build this blog- “ExcelTip2Day-Shortcut, Trick, and Solving Methods”?

As far as you may know, nowadays the Excel office, the one out of the several programs, which is commonly accompanied by the Microsoft window, is extremely useful for most working offices across the world.

Many years ago, when I have been just the newcomer staff joining the international company. They gave me the PC with some basic Microsoft office programs besides the warehouse management system.

At that time, I was not only the newbie for this the company, the apparel business type but also the PC and all related programs in it.

In the meantime, my boss was French. He is a very good guy. He taught me how to of the program work, particularly the Excel office.

I thank and appreciate him a lot since he sympathizes with me.

That’s why, after I have learned more and more about Excel, it’s time for me to forward a little knowledge for you and or anyone who is interested or facing any obstacle in the Excel office.

That's the end of my posting for today.

Tip: Answer

 a. It's Ctrl + Alt+ Up Arrow.

 b. It's Ctrl + Up Arrow.

 c. It's Alt + Up Arrow.


Link recommended👉 : To Redo Last Action (Multiple Levels) Excel Shortcut Key.
Link recommended👉 : English Numbers In Words 1 to 1000000

Don't forget to follow me and please leave any comments, thus, I could use them for my future articles improvement.

That's the end of my posting for today, don't forget to follow me and please leave me any comments, thus, I could use them for my future articles improvement.

See you again in my future article,

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.

See more articles:

Comments

Popular posts from this blog

5 Alternative Shortcut Ways Minimize Your Excel Workbook, Read It Now! | ExcelTip2Day

Do you use Microsoft Excel? If yes, stay with me—I’ll show you how to manage your Excel workbook effortlessly. Hello, I’m Michael Leng. Today, I’m excited to share  five ways to minimize an Excel workbook to an icon . Tip Quiz What to do if your monitor screen upside down? These methods apply to   Excel 2013   (the version I use) and are for   Windows   operating systems. I’ve discovered and tested  five different techniques , which I’ll explain below. 5 methods minimize Excel workbook. ⟴ Use shortcut keys  "Ctrl" and "F9" ⟴   Use shortcut keys  " ALT",  "Spacebar" and "F9" ⟴   Click on the "Minimize workbook" square box. ⟴   Clicking on the "Minimize" command in the "Quick Access Toolbar" ⟴   Use shortcut keys "Window Logo" and "M" To make you more ease seeing all the four pictures clearly, I have made the construction of all the methods for you to follow any of...

🚀 Excel Shortcut Tips: How to Use [Ctrl] + [.] (Period) to Move Clockwise in a Selected Range

Hello there! 👋 I'm Michael Leng , and welcome back to my blog “Exceltip2day” —your friendly place for quick, powerful Excel tips. In today’s post, we’re going to explore a handy Excel shortcut: 👉 [Ctrl] + [.] (Period or Full Stop) This small but mighty shortcut helps you move clockwise between the corners of a selected range in Excel —especially useful when working with large datasets. 🔍 Why Should You Learn This Shortcut? ✅ To navigate quickly around the selected area without using the mouse. ✅ To check the four corners of large tables or selection ranges. ✅ To save time and avoid getting “lost” in big spreadsheets. 📝 How Does [Ctrl] + [.] Work? When you select a range in Excel, pressing [Ctrl] + [.] will take you from one corner to the next in a clockwise direction. Here's how to do it: Select your cell range. Press and hold [Ctrl] . Press the [.] (Period/Full Stop) key. Release both keys. Press again to keep moving around the corners....

Shortcut Keys How To Fixing Window Screen Accidentally 'Upside Down' | ExcelTip2Day

"How do you fix your Window Screen Upside Down?" Hello there! My name is Michael. Welcome everyone to blog. Is it good to know some tip how to fix your PC screen upside down accidentally? Why do I post this article?  Because I have faced this trouble before while I have taught one of my friend typing on the PC. Then after I have spent too much to solve this kind of problem I would like to share with anyone who might come up with this such a magic case!!! Screen 'Upside Down' Fixing In this post, you will see how to fix the " Unintentionally Upside Down Monitor Screen " Tip Quiz Is there any shortcut to minimize an Excel Workbook? If someone questioned me, “How will I able to fix such as the error  as the mention above?” I would doubt. How about you? Don't worry. Today I'm going to show you how to solve it. Hello everyone. My name is Leng, You can see me and my posts about Excel tips, shortcuts, and how to fix...