In the previous article, we learnt about the VBA elements which may constitute together to make a subroutine. In this article let’s look these elements in details. Comments A comment is descriptive text in VBA Code. It’s a good idea to use comments to describe what you’re doing. A comment is indicated by an apostrophe ( […]
VBA Fundamentals-2 Read More »
VBA Language : An Overview This Article shows the VBA language elements, which are the keywords and control structures that are used to write VBA routines. Take a look at the following VBA Sub procedure. The procedure, calculates the sum of the first 10 integers. When the code finishes executing, the procedure displays a message
VBA Fundamentals-1 Read More »
Substring Small strings inside a STRING. For example A STRING: “India is a Great Country” Substring can be India is India Great country Is a great So on…. You might want to extract the first few letters of a STRING. Excel gives you three functions for extracting substrings, as described in the next three sections.
Working with Substrings Read More »
We are familiar with the decimal number system in which digits are 0, 1, 2, 3, 4, 5, 6, 7, 8 and 9. The computer uses binary digits for its operation. In the binary system there are only two digits 0 and 1. We will look the other two number systems: Octal Number system and
Number System in Computer System Read More »
