Last Updated on February 8, 2023 by token Constant values in VBA – what is it? In the previous chapter of the course you learned what are the VBA variables using in your VBA code. The difference between variables and constants in VBA is the values assigned as constant will not change during […]
Yearly Archives: 2018
42 posts
Last Updated on January 11, 2023 by token Introduction to VBA variables In VBA, as in other programming languages, we work with variables. The VBA language does not require declaring variables. You can, for example enter variable name that will be interpreted as a variable, and then you can execute any instructions […]
Last Updated on January 11, 2023 by token Formatting cells and fonts in VBA – introduction Cells as well as other elements of the Excel spreadsheet can be formatted from the VBA code level. The formatting itself can be done in 2 ways. The first way is to set each format using […]
Last Updated on January 11, 2023 by token InputBox window – entering data into VBA It’s great, that you have already reached this part of VBA tutorial. After the VBA MsgBox window you will learn how to work with window for entering data into our VB code. Like the MsgBox […]
Last Updated on January 11, 2023 by token VBA MsgBox – data presentation in window You have lerned basics of VBA MsgBox window while writing your first program here: VBA first program. This window is one of many possibilities to present something using VBA code in Excel. It can be use […]
Last Updated on January 11, 2023 by token 1. How to use VBA in Excel worksheet It’s great that you’ve already reached this part of the VBA Excel training. In this chapter we will learn in detail the possibilities offered by the VBA in the Excel worksheet. If you are […]
Last Updated on January 11, 2023 by token 1. What is macro in Excel In this part of VBA course you will learn how to record and run macros under Excel program. As you already know Macros in Excel are programs which are running under Excel. Each of those programs […]
Last Updated on January 11, 2023 by token 1. How to write first program in Excel VBA If you already know what macros are and what the VBA is, it’s time to write your first program in VBA. First of all we would like to fill A1 cell in the […]
Last Updated on January 11, 2023 by token VisualBasic Editor – Introduction The VisualBasic editor will be the tool that you will use in this course. In order to take full advantage of the VBA option on your computer, you should start with: Unlocking the Developer tab in Excel Enable […]
Last Updated on January 11, 2023 by token Excel VBA Tutorial – What is Excel VBA? VBA Online Course Why do we use VBA? You can use the VBA code in Excel for example to: Create useful macros Make own functions, ie. functions that Excel doesn’t have Create Excel add-ons […]