Categories：Excel Tips
-
VBA Variable Basic Tutorial
In the last chapter “Excel VBA Basics”, we learned some basic concepts and operations. In some tutorials, Some specific VBA code would appears, which you may not understand. But it doesn’t matter. From the beginning of this chapter, we will learn the grammar part of VBA specifically, which will take you into the real VBA […]
-
How to Run the VBA Code in Excel?
This article will introduce various methods of how to run VBA in Excel. Different methods are applicable to different situations, and one of them can be used according to specific needs. The “run” mentioned in this article refers to running in the Excel interface, not in the VBA editor. Generally speaking, there are three ways […]
-
Write the First VBA Macro by Yourself
Through the previous tutorials, we have a basic understanding of Excel VBA, and you maybe have initially learned to use the VBA editor. If you haven’t read it yet, it is recommended to read and study first. In this tutorial, the author will introduce how to write a VBA macro from scratch, that is, a […]
-
Use the VBA Editor in Excel
A workman must first sharpen his tools if he is to do his work well. The VBA editor is the core development tool. It can be said that almost every step in Excel VBA development is carried out in the VBA editor, including writing, debugging, testing, running, and code organization. This article mainly introduces the […]
-
How to Save the Workbook Containing VBA Code
Starting from the 2007 version of the office, when saving a workbook containing VBA code for the first time, Excel will prompt “cannot be saved in macro-free workbooks”. This is because the workbook containing VBA code must be saved as a macro-enabled workbook type. Excel provides an xlsm type workbook for this purpose, which is […]
-
Excel VBA: Inserting Photos as Comment in Bulk
When we use Excel to make some product price lists or personnel lists, we will add a picture to the cell behind the name to give a hint. Will you insert these pictures one by one, and adjust the size. Today, the author will share with you guys a perfect method which can insert photo […]
-
How Does Excel Automatically Record the Time of Data Entry?
In our daily work, sometimes we will often enter the current time in the form. But every time we enter it manually, is there a faster way? Today, the author will introduce to you a method of automatically recording the time of data entry. This can help us quickly improve office efficiency. Open an Excel […]
-
Excel VBA: Set Macro Security
Under normal circumstances, we will not open the VBA code of a workbook whose source is unknown. Because this is likely to cause computer poisoning. So by default, Excel will disable the running of macros. But we hope to be able to run the VBA code written by ourselves, or other VBA code we consider […]
-
The Excel Developer Tutorial
We need to use various commands included in the developer tool. By default, the developer tool option is hidden, you may need to manually enable it. After enabling it for the first time, this tab will be displayed by itself every time you open a file. Enable Developer We just need to right-click on a […]
-
8 Super Practical Skills of the Alt Key in Excel
We all know that the Alt key is a very useful shortcut key in our daily work. In fact, the Alt key is also very easy to use in Excel. Today the author will share with you eleven tricks of this shortcut. Hurry up and learn! 1. Move Cells or Tables Quickly We can use […]
