Thursday, August 18, 2022

How to open Visual Basic Editor under Microsoft Excel?

Visual Basic Editor (VBE) is the place to write and store all Visual Basic code and Macro recorded code. This VBE attached to all office application for example Microsoft Word, Microsoft PowerPoint and etc. but in this blog our focus only VBE in Microsoft Excel. To open this VBE:

Two ways to open Visual Basic Editor in Excel:

  1. 1st Method: Under Developer tab click at Visual Basic.









    Click here if Developer tab is not visible.

  2. 2nd Method: Short cut key by Pressing Alt + F11 button.

  3. Visual Basic Editor will open as below:



















 

Practice makes perfect. Thank You.

No comments:

Post a Comment