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

Olimpiade Matematika Internasional

Online Mathematics Tutorial by : Dr. Roohollah post by : cumicumicommunity ini adalah salah satu video yang sangat berkesan, karena memberikan sebuah ispirasi tentang pembelajaran matematika. adanya persiapan bagi siswa dalam mengikuti kejuaraan olimpiade internasional adalah motivasi terbesar saya untuk terus berkarya melakukan yang terbaik bagi siswa saya di SMP Cipta Dharma. Agar mereka senantiasa memiliki motivasi yang tinggi untuk berkarya dan memberikan prestasi tertinggi mereka bagi Sekolah,. itulah perjuangan saya..... 
Posting Komentar
Baca selengkapnya