归档： Sandra
-
Useful Excel Tips & Tricks You Should Know
This is a perfect and excellent article If you still use Excel frequently in your work or study, The so-called multi-skills are not pressure. So, today, the author will share some useful Excel tricks. Come and learn! Skill 1:How to Make Your Excel Data More Intuitive? When you first look at this table, can you quickly find the […]
-
VBA Operator Basic Excel Formulas Tutorial
VBA provides many operators, which can be used to implement complex operations. Today, the author will share the basic operators and operations provided by VBA, and their basic usage. VBA operators can be divided into the following 6 categories: Assignment operator Arithmetic Operator Comparison operator Logical Operators Concatenation operator Other operators Assignment Operator The first […]
-
VBA Constant Basic Tutorial
VBA constants are relative to the concept of VBA variables. Unlike variables, once a constant is assigned, its value cannot be changed. During the entire process of the program, its value remains unchanged. If new data is assigned forcibly, VBA will report an error. Using VBA constants can make a value expressed in a more […]
-
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 […]
-
Black Friday Super Sale – Get windows 10 for free.
Do you know that you can make upcoming Black Friday super for you with GoDeal24.com Black Friday Super Sale? One of the biggest deals of the year is running only during the Black Friday super sale and you have the chance to claim it today. Feel like a superhuman this Black Friday with our “Buy […]
-
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 […]
