Langsung ke konten utama

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

Komentar

Posting Komentar

Silakan Tinggalkan Pesan Terhadap Blog ini,
Terima Kasih Atas Kunjungannya

Postingan populer dari blog ini

Solving Problems in Mathematics

About Solving Problems Now we've seen a problem and worked out a solution, however rough, let's look at the whole business of problem solving. There is no way that at the first reading i can expect you to grasp all the infinite subtleties of the following discussion. So read it a couple of times and move on. But do come back to it from time to time. Hopefully you'll make more sense of it all as time goes on. Holton's Analysis of solving problems a. First take one problem . Problem solving differs in only one or two respects to mathematical research. The difference is simply that most problems are precisely stated and there is a definite answer (which is known to someone else at the outset). All the steps in between problem and solution are common to both problem solving and research. The extra skill of a research mathematician is learning to pose problems precisely. Of course he/she has more mathematical techniques to hand too. b. Read and understand . It is often nec...
Posting Komentar
Baca selengkapnya

Making Education Fun

The best way to make education a fun experience url :  http://www.helium.com/knowledge/8887-the-best-way-to-make-education-a-fun-experience Educational Activities: How My Favorite Teacher Helped Make Learning Fun examples of fun educational activities one can use to make learning fun. Being that September 28th is known as National Teachers Day, or National Teacher Appreciation Day, I will take some time to honor a particular second grade teacher and lifelong friend. This woman, known as Miss Jane Keil, impacted my life in so many wonderful ways. She not only contributed to a well rounded, extraordinary education at an exceptional elementary-level school, but she provided just the right formula of guidance and encouragement necessary for me to march into the rest of my life with goals, independence, and enough confidence to explore my personal individuality. She was the kind of teacher that truly cared about each child and his or her future and who was committed in her heart and sou...
Posting Komentar
Baca selengkapnya