tailieunhanh - Introduction to using macros in Microsoft Excel 2003 phần 1

Hướng dẫn này cung cấp một giới thiệu tiểu sử dụng macro trong Excel 2003. Instaructions được đưa ra cho các macro ghi âm, và viết các macro đơn giản trong Visual Basic cho các ứng thiệu về sử dụng các macro trong Microsoft Excel 2003 | Information Technology Service Guide 39 Version 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 Document code Guide 39 Title Introduction to using macros in Microsoft Excel 2003 Version 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 2 Recording and running Recording a macro which uses absolute cell Running a macro using the Macro dialog Recording a macro which uses relative cell Running a macro using a shortcut 3 Making a macro easier to Running a macro from a drawing object on a Running a macro from a button on a Running a macro from a command on one of Excel s Changing macro 4 Editing a General Making 5 Visual Basic Properties. 14 Variables. 15 Using Dim . 15 Constants. 16 Using 6 .