Excel VBA is the macro programming language available in the Excel and other MS office tools. It helps to automate the regular tasks, create the dashboards and build the tools to perform certain tasks.
Description: In the previous post we have seen, how to [...]
We 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.
Examples 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.
When 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.
It 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.
We 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
When 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:
Examples to Copy Files from One Location to Another folder or directory in Excel VBA - if File does not exists in the source or already in the destination.
Example code to Check if file Exists in Location using Excel VBA. We can use FileSystemObject and FileExists, Dir functions.
Hyperlinks in Excel VBA - Examples to add, create and remove hyperlinks, opening files using hyperlinks and sending emails using hyperlinks in Excel VBA.
Effectively Manage Your
Projects and Resources
ANALYSISTABS.COM provides free and premium project management tools, templates and dashboards for effectively managing the projects and analyzing the data.
We’re a crew of professionals expertise in Excel VBA, Business Analysis, Project Management. We’re Sharing our map to Project success with innovative tools, templates, tutorials and tips.
Download Free Excel 2007, 2010, 2013 Add-in for Creating Innovative Dashboards, Tools for Data Mining, Analysis, Visualization. Learn VBA for MS Excel, Word, PowerPoint, Access, Outlook to develop applications for retail, insurance, banking, finance, telecom, healthcare domains.
