Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
In Excel, you can automate tasks by using macros. A macro is a set of instructions that tells Excel what to do. These commands are written in a computer programming language called Visual Basic for Applications (VBA). This document first explains how to create macros using the Macro Recorder provided by Excel. Just as a tape recorder can be used to record sounds which can be played back later, so the Macro Recorder can record your actions into a macro. In this way you can create macros without learning about Visual Basic. These macros can be run whenever you wish, automatically repeating your recorded actions and so saving. | Information Technology Service Guide 39 Version 1.0 Introduction to using macros in Microsoft Excel 2003 This guide provides an elementary introduction to using macros in Excel 2003. Instructions are given for recording macros and for writing simple macros in Visual Basic for Applications. Durham University 1.50 Document code Guide 39 Title Introduction to using macros in Microsoft Excel 2003 Version 1.0 Date June 2006 Produced by University of Durham Information Technology Service Copyright 2006 University of Durham Information Technology Service Conventions In this document the following conventions are used A typewriter font is used for what you see on the screen. A bold typewriter font is used to represent the actual characters you type at the keyboard. A slanted typewriter font is used for items such as filenames which you should replace with particular instances. A bold font is used to indicate named keys on the keyboard for example Esc and Enter represent the keys marked Esc and Enter respectively. A bold font is also used where a technical term or command name is used in the text. Where two keys are separated by a forward slash as in Ctrl B for example press and hold down the first key Ctrl tap the second B and then release the first key. Contents 1 Introduction.1 2 Recording and running macros.1 2.1 Recording a macro which uses absolute cell references.1 2.2 Running a macro using the Macro dialog box.3 2.3 Recording a macro which uses relative cell references.3 2.4 Running a macro using a shortcut key.4 3 Making a macro easier to use.4 3.1 Running a macro from a drawing object on a worksheet.4 3.2 Running a macro from a button on a toolbar.6 3.3 Running a macro from a command on one of Excel s menus.8 3.4 Changing macro options.10 4 Editing a macro.10 4.1 General form.11 4.2 Making changes.11 5 Visual Basic Grammar.12 5.1 Objects.12 5.2 Methods.13 5.3 Properties. 14 5.4 Variables. 15 5.5 Using Dim . 15 5.6 Constants. 16 5.7 Arrays.16 5.8 Using Set.17 6 .
