Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Writing VBA code in Excel: Entering and Editing code

In our preceding articles, we have demonstrated the easiest way to create simple macros using the macro recorder. To make complex macros, you have to write a program using VBA. To save time in developing your macro, you can combine both: recording and manually code entry.

Before you can start writing your own VBA code, you must have a good understanding of these topics: objects, properties, and methods. It is also necessary to be familiar with common programming constructs, such as looping and If-Then statements.

In our this and next some articles, we shall introduce you with VBA programming that is essential to write VBA macros. It is not a complete instructional guide. We shall cover all the topics of VBA and advanced spreadsheet application development in another devoted page.

The basics: Entering and editing code

Before you can enter a code, you must insert a VBA module into the workbook. If the workbook already has a VBA module, you can use the existing module sheet for your new code.

Follow these steps to insert a new VBA module:

  1. Press Alt+F11 and VB Editor window will be activated. The Project window displays a list of all open workbooks and add-ins.
  2. In the Project window, find out and select the workbook you’re working in.
  3. Choose Insert ➪ Module. VBA will insert an empty and new module into the selected workbook. The code window will display the Module.
Writing VBA code in Excel: Entering and Editing code

1) After selecting the destination (here the workbook) 2) choose Insert->Module 3) Code window will be displayed.

A VBA module is like a text editor. It is displayed in a separate window (Code window). You can select text, copy and cut text, insert and paste text into it, move through the sheet, and so on.

Happy Excelling 🙂

Read More

Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply