Dear All Readers today, We will show you how to use Visual Basic Editor in Excel. In this tutorial you can see the tips below:
When you want someone to work for you and you just open the Email and send him a message he understands like ( English , Spanish , French ... ) at that time , he will open the Excel and work for it..
It is the best way to develop . VBA development through VBE is a part of the Workbook that allows you to keep these commands include (Macro, Modules, userforms and many other Components ) . But if you put that file in the Recycling Bin , means that you will have to destroy all VBA procedures .
Note
- For the use of Microsoft Excel 2007 as usual , you can not work with the Macro in Excel , as when you installed click choose VBA for Application and click Continue.
- It will not affect your computer or Excel program , but if you do not trust that you can try try installing it again .
- You use Excel 1997-2006 first what you have to do is set the Security level from Low or Medium can use the Macro (VBA procedures) that you have developed . In the menu bar choose Tools and click Macro and select Security , then you must click Medium.
- For users of Excel 2007 and 2010 , you just click on the Macro Security , and then click on the Disable all Macros with Notification and then you can run and .
Way Visual Basic Editor (VBE) in Excel
Visual Basic Editor is a program that can make Excel can relate to another Excel easily . To open the program you are going to program your Microsoft Excel and press ALT + F11 when it will issue a tab .
But if you do not set the VBE , it will issue a tab in
3 tab in the Visual Basic Editor
When you apply with VBE it will have Windows 3 as KH4IT shows you read about each tab as follows : Tab 1st , 2nd Code tab tab tab tab Properties tab 3 is for preparing the image below . So you can resize its size or change its tab .
Learn to create and use Macro test yourself
KH4IT will take the example of creating a Macro to tell all of your friends read this , we will show how the same method follows :
1 . You have to close the form that you opened in the VBE to start
2 . You have to click into the menu bar and click on View and click on the Project Explorer , and it will issue the following results
If the Project tab , it already came out on the Left Side of the screen means that it does not have anything to do , but if Project tab in half , you have to right click and choose Dockable then you have to click on the blue bar above then you pull it to the left until the Cursor side center of the screen . At that time , it will release the results of the installation VBE.
3 . Change Your Mouse to the difference between the Project tab and gray tab at that time , it will have line of a small group of two parallel you have to click on it and put it on the other hand, you can also change the size according to your preferences too .
4 . You have to go back to the menu bar , click View and click on the Properties Window. In the properties view , it will issue the following
If the properties tab it shows the project tab , and that means it does not have anything , but if it comes same as above , you need to click right click on the central space of the properties tab and click on Dockable. Then you have to click on the blue bar above then you pull it to the left until the Cursor Side the center of the screen . At that time , it will release the results of the installation VBE.
5 . Change Your Mouse to the difference between the Project tab and tab Properties. At that time , it will have a line of parallel two small children then you have to click on it and put it on the other hand, you also can change the size of the tab according to your preferences .
6 .or Workbook ) , then the code will be released in the gray tab . You can also put a huge chunk of code by clicking on the button Maximize.
Final results will be released as follows tab . And the word "Option Explicit" It will not on your Code . At that time , we were put Address on Variable you also need to have VBA Project name FUNCRES.XLA or FUNCRES.XLAM in the Project tab .
7 . Now you can go into your Excel program then you need to close and re - open and then you can press ALT + F11 when you will see the installation VBE your decision .