How to open VBA in Excel

Are you going to get into a VBA? Or do you want to do VBA's **?

Not sure what you're asking.

But first your machine must have VBA installed

Run the setup in the installer (the version you already installed) to add and remove the module, and in the "Office Sharing Features" there is "Visual".

basicfor

After starting excel, select the big dot in the upper left corner, excel options -> Trust Center -> Trust Center Settings -> Macro Settings -> "Disable macros and send a notification".

At this time, when opening Excel with VBA, there will be a prompt on the side of the column, which must be enabled, otherwise VBA cannot be used.

Alt+F11, open the VBA machine, you can write ** by yourself, you can also read the existing ** here.

If it is a macro, you can directly alt+f8

Select Execute.

You can use the Record Macro option in the development tools menu in Excel to record the macro (VBA), and then click View to open the window to see the macro you just recorded (VBA program);

Alt+F11 can open the VBA window by pressing and holding at the same time, then click the insert menu to insert the module, and then you can write VBA programs in the module (all programs are saved in the module).

Once you've written it, you must save it as a macro-enabled workbook to save the program you wrote.

First, open the Excel software and click on the File menu in the upper left corner. Next, select the options menu in the bottom left corner. Select the development tools that automatically take the ribbon. Precession: Click on the development tools menu at the top. Click Visual Basic

Button. Finally, you can open the VBA area. <

Demo model: Huawei MateBook X System version: Win10 APP version: Excel2020 1. First open the excel software and click on the file dish in the upper left corner.

2. Then select the options menu in the bottom left corner.

3. Select the development tool that automatically takes the ribbon to the ribbon.

4. Click the development tools menu at the top.

5. Click the Visual Basic button.

6. Finally, you can open the VBA area.

Excel computer.

Method steps.

Method 1: Shortcut keys.

alt+f11.Open Excel and press the Alt and F11 keys at the same time.

Please click Enter a description.

Method 2: Click File and select Options.

Please click Enter a description.

Click Customize ribbon. Find Developer Options. Check.

Please click Enter a description.

Find the development tools in the toolbar.

Please click Enter a description.

Click Visual Basic

Please click Enter a description.

This allows you to enter the required ** to complete the programming.

Please click Enter a description.

In the above mode, you can open the VBE.

In the Project on the left, you can select the Workbook area.

As well as modules, classes, forms, etc., and then you can test the relevant areas.

1. Open an excel file and right-click on the worksheet below (e.g. sheet1). Select "View**" to open the VBA interface;

from the drop-down menu, select the "Worksheet" option function;

3. Select BeforeDoubleClick, that is, double-click the mouse in this worksheet (before), and the following ** program will be touched and bent Yu Yu;

4. After the selection is completed, you will see two ** below; These two ** are actually declaring a function;

5. Place the mouse between these two lines of **, and write the execution statement:, 3) =, 1) +2);

6. Then click Save to return to the original interface of Excel. Enter two values in cells(1,1) and cells(1,2); Buried segments.

7. In the sheet of sheet1, double-click the mouse and you will find that the value of cells(1,3) becomes the sum of cells(1,1) and cells(1,2).

In Excel, often because of the need to use programming to assist in the hall, this time you need to open VBA, VBA is closed in the default settings of Excel, we need to open the bridge by ourselves, the following is the Excel2010 open VBA method shared by me, I hope it will be useful to you.

Excel2010 open VBA method:

Open VBAStep 1: Click on the "File" button.

Open VBA Step 2: Click the "Options" button of Min Fu Hui.

Open VBAStep 3: The Excel Options dialog box appears.

Open VBAStep 4: Click on "Customize Ribbon".

Open VBAStep 5: Put a check mark in front of "Development Tools" and click OK to complete the setting.

Open VBA Step 6: Select "Development Tools" - "Visual Basic" on the ribbon

1. Use tools: excel2010

2. Steps: