Write Data to Worksheet Cell in Excel VBA
PNRao2022-06-17T03:52:55+05:30Description: In the previous post we have seen, how to [...]
Entering Data and Moving in Excel Worksheet
PNRao2022-06-17T03:54:03+05:30Entering Data and Moving in Excel Worksheet is very easy . You can enter any numbers, text, dates in Excel and you can format as per your requirement.
Data Validation in Excel – Adding Drop-Down Lists in Excel
PNRao2022-06-17T03:55:31+05:30Data Validation is a feature available in Excel to define restrictions and what data can enter in a cell. For example,
- We can restrict data entry to a certain range of values
- User can select a choice form predefined list
- We can display a message to provide the instruction to the user
- We can display a message when user enter an incorrect value
Passing Arguments in Excel VBA
PNRao2022-06-17T03:53:53+05:30We write the procedures to perform certain tasks and some times we may required to write another procedure with small variations. In this situation we can take advantage of the Passing Arguments.
In this Section:
- What are By Value (ByVal) and By Reference (ByRef) Passing Arguments?
- Writing a procedure or a function with Arguments
- How to call a function or a procedure?
- Example macro file to explain passing arguments
Arrays in Excel VBA
PNRao2022-06-17T03:53:54+05:30When we work with one item we required to use one variable, if you want work with more than one item, we can go for arrays. Arrays are the variables which allow us to store more than one value.
In this topic:
- What is an Array?
- What are the different types of arrays?
- One Dimensional Array:
- Multi-Dimensional (Two Dimensional) Arrays:
- How to Re-size an Array?
- Array Options
- Example File
Change Font Color in Excel VBA
PNRao2022-06-17T03:52:56+05:30Examples will show you how to change Font Color in Excel using VBA. While preparing the reports we change the font colors based on data Or a template.
Read or Get Data from Worksheet Cell to VBA in Excel
PNRao2022-06-17T03:52:55+05:30It is very simple to Read or Get Data from Worksheet using VBA, There are may ways to read the data from Excel to VBA. See the examples explained Here.
Introduction to Excel Interface and Objects
PNRao2022-06-17T03:54:01+05:30We have seen what is Excel and what we can achieve using Excel in the previous section. I n this section we will what are the different objects in Excel to do our jobs and piectorial representation of Excel Interface. In This Section:
- Introduction to Excel Interface
- What are the Objects in Excel?
Delete Rows and Columns in Excel VBA
PNRao2022-06-17T03:52:57+05:30We can delete rows in Excel using VBA. We can specify a condition to delete. There are number of examples to show you dealing with deleting records in Excel
Scope of Variables in Excel VBA
PNRao2022-06-17T03:53:53+05:30When we are working with variables, it is important to understand the Scope of a Variable. The Scope describes the the accessibility or life time or visibility of a variable. There are four levels of Scope:
- Procedure-Level Scope
- Module-Level Scope
- Project-Level Scope
- Global-Level Scope
ANALYSISTABS Version 1.0.0
PNRao2022-06-17T03:56:15+05:30Finally I am all set to release the first version of Excel Add-in. I have been postponing this from the last few months due to busy at my professional work. This version have the following features.
Introduction to Microsoft Excel and Creating First Excel File
PNRao2022-06-17T03:53:55+05:30Microsoft Excel is one of the tools in the Microsoft Office Package; it is used to create spreadsheets. It has many in-built functions and tools to work with data and create different type of reports and dashboards. It also provided the feature to the users to work behind the existing tools and can enhance its capabilities. To implement functionality beyond a regular spreadsheet, Microsoft Visual Basic programming environment is provided with Microsoft Office Excel. This programming language is called as Visual Basic for Application (VBA). In This Section:
- What is Excel?
- Why is it used?
- Creating your first excel workbook.