https://wiki.itcollege.ee/api.php?action=feedcontributions&feedformat=atom&user=Ktarkin 2026-06-13T13:09:29Z User contributions MediaWiki 1.45.1 https://wiki.itcollege.ee/index.php?title=Category:Office_Software_Programming&diff=14010 2010-10-12T15:12:21Z

<p>Ktarkin: /* Homework2 */</p> <hr /> <div>=Aim of this course=<br /> The course deals with programming in software packages Microsoft Office. The features of the programming language Visual Basic for Application (VBA) in spreadsheets on the basis of Excel are studied thoroughly. The course has an applied trend.<br /> <br /> <br /> <br /> =Books=<br /> ==Estonian==<br /> *<br /> *<br /> *<br /> <br /> ==English==<br /> *<br /> *<br /> *<br /> <br /> <br /> <br /> =What we do?=<br /> ==Introduction==<br /> * Create a Macro http://www.excel-vba-easy.com/vba-how-to-create-macro-excel.html<br /> <br /> ==Recording and executing macros==<br /> * Excel Macro Recorder http://www.excel-vba-easy.com/vba-how-to-excel-macro-recorder.html<br /> * Macro Security http://www.excel-vba-easy.com/vba-basic-macro-security.html<br /> * Practice1: http://www.wiseowl.co.uk/training/exercises/ex-1733.htm<br /> * Practice2: http://www.wiseowl.co.uk/training/exercises/ex-1731.htm<br /> ** More: http://www.wiseowl.co.uk/training/exercise-list/t-1426.htm<br /> <br /> ==VBA language==<br /> * Getting Started with VBA in Office 2010 http://msdn.microsoft.com/en-us/library/ee814735.aspx<br /> * Visual Basic for Applications (by wikipedia.org) http://en.wikipedia.org/wiki/Visual_Basic_for_Applications<br /> * Visual Basic Editor http://www.excel-vba-easy.com/vba-basic-visual-basic-editor.html<br /> <br /> ==Simple VBA programming==<br /> * Developing Macros in Excel http://www.excel-vba.com/vba-prog-1-5-new-macro.htm<br /> * Testing Macros in the Visual Basic Editor for Excel http://www.excel-vba.com/vba-prog-1-6-testing-macros.htm<br /> * Practice1: http://www.wiseowl.co.uk/training/exercises/ex-1741.htm<br /> * Practice2: http://www.wiseowl.co.uk/training/exercises/ex-1742.htm<br /> <br /> ==Variables in VBA==<br /> * Variables http://www.excel-vba-easy.com/vba-programming-excel-vba-variable.html<br /> * MsgBox http://www.excel-vba-easy.com/vba-basic-msgbox.html<br /> * Objects, Properties and Methods http://www.excel-vba-easy.com/vba-basic-objects-properties-methods.html<br /> * Workbook and Worksheet http://www.excel-vba-easy.com/vba-basic-workbook-worksheet.html<br /> <br /> ==Conditional branching in VBA==<br /> * If Then Statement http://www.excel-vba-easy.com/vba-programming-if-then-statement.html<br /> <br /> ==Looping through code==<br /> Loop http://www.excel-vba-easy.com/vba-programming-excel-vba-loop.html<br /> <br /> ==Building procedures and functions==<br /> <br /> ==Building User Interfaces==<br /> =Homework=<br /> ==Homework2==<br /> * Ex 1 http://www.wiseowl.co.uk/training/exercises/ex-1743.htm kadri<br /> * Ex 2 http://www.wiseowl.co.uk/training/exercises/ex-1742.htm Nino<br /> * Ex 3 http://www.wiseowl.co.uk/training/exercises/ex-1732.htm Riina<br /> * Ex 4 http://www.wiseowl.co.uk/training/exercises/ex-1853.htm<br /> * Ex 5 http://www.wiseowl.co.uk/training/exercises/ex-1736.htm <br /> * Ex 6 http://www.wiseowl.co.uk/training/exercises/ex-1735.htm mariliis<br /> * Ex 7 http://www.wiseowl.co.uk/training/exercises/ex-1761.htm mirjam<br /> * Ex 8 http://www.wiseowl.co.uk/training/exercises/ex-1853.htm kerli<br /> * Ex 9 http://www.wiseowl.co.uk/training/exercises/ex-1742.htm</div>

Ktarkin