Recording your first MacroMicrosoft Excel 2007 provides you a very helpful option which enables you to record a macro and also modify and run afterwardsMicrosoft Excel 2007 don’t provide you the macro recording option by default for enabling macro recording at first you need to enable the Developer Tab, next slide defines step by step procedure to enable Developer TabĮnabling the Developer TabClick on Office ButtonClick on Excel OptionsOn Popular Tab checkShow Developer tab inRibbonĮnabling the Developer TabOnce you are done with the process you will have the Developer Tab ready if we talk about VBA for Excel it can use Cell Object, Range Object, Worksheet Object, Workbook Object etc. Introduction to Visual Basic for Application - cont…Visual Basic for ApplicationVisual Basic for Application is called VBA as it uses Visual Basic language and is capable of using application specific objects i.e.
we can use the Worksheet object and its property SheetName when some one clicks on a button It’s an event driven & object based language.What is Event Driven Language?When we say event driven it means that you can write triggers which will initiate on specific events for example when user opens any document or saves any documentWhat is Object Based Language?Object based language is language in which we can use objects & their properties i.e. Visual Basic is called visual as you can do most of the program by click and go i.e. BASIC stands for Beginners All-purpose Symbolic Instruction Code.
Introduction to Visual Basic for Application - cont…What is Visual Basic?Visual Basic is a language which is inherited from a very popular language BASIC. Introduction to Visual Basic for Application - cont…Apart from automating repetitive tasks Microsoft Excel Macros may also be used to create user interfacesUser interfaces are screens where user can give inputs with ease also it enables input validations Microsoft Excel 2007 macro is the feature which eliminates or at-least minimize these events which take your precious time in repetitive tasks, and you will be able to capitalize this time in more productive & strategic activities.
This tool is one of the ultimate timesaver, but there are numerous events when you have to do repetitive tasks which are of a very little value but consume your precious time yet engage you in a less productive activity, which Excel may do automatically. Introduction to Visual Basic for ApplicationMicrosoft Excel 2007 in itself a tool which helps users to work with worksheets & workbooks with ease.
#INTRODUCTION TO MICROSOFT EXCEL 2007 FOR ABSOLUTE BEGINNERS CODE#
Introduction to Microsoft Excel 2007 MacrosĬontentsIntroduction to MacroIntroduction to Visual Basic for ApplicationRecording a MacroLooking at the code of Recorded Macro