Cara Mudah Memahami Matematika

Excel Macro for Mathematics

by : Putu Eka Putra, S.Si

www.cumicumicommunity.blogspot.com 

Ubud, 30 Juni 2012

Have you ever used microsoft excel vba, to improve your skill on mathematics?, Well, i think you ever been. Ok. In this articles i would like introducing "How Excel 2007 can use for Mathematics". before i tell you more about it. You have to know VBA first.

Visual Basic for Applications (VBA) is an extensible programming language that is made up of a core set of commands and extended on a per-application basis to be able to work directly with objects in that application.  This means that VBA for Excel knows about things like workbooks, worksheets, cells and charts and more; while VBA for Access knows about tables, queries, reports and data entry forms, among other things.  The core can even be licensed for use by 3rd party companies to permit it to be used with their application(s).  This was the case with Visio before Microsoft bought the product for use under their banner. 

VBA can probably be best described as an object-based (but not a true object oriented) language that is event driven.  Let’s look at the event driven side of it first.

The Excel VBA IDE

The Excel VBA IDE (Integrated Development Environment) has not changed in quite some time.  This is a good thing – the interface in Excel 2007 is the same as it was in Excel 2003, 2002 (XP), and even back to Excel 97 , and that means that no time is wasted for programmers in learning a new interface just to be able to continue to use a language they are already familiar with.  There are 5 major areas of the IDE and I like to work with all of them visible.

if you want to know more. i have some site that had discussed and give us step by step how to make it.

click here excel functions. net well if you a beginner i think this site appropriate to try. click here microsoft office training.

Have fun to learn at CumiCumiCommunity