TAILIEUCHUNG - Introduction to using macros in Microsoft Excel 2003

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 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 .

• Tin học văn phòng
• running macros
• Visual Basic Grammar
• Making a macro
• Microsoft Office
• Excel 2003
• macros in Excel
• macro
• Running a Macro
• Editing a Macro
• Change action arguments
• Grouping Macro Actions
• Excel programming
• Getting started with excel macros
• Using the visual basic editor
• VBA programming basics
• Working with the excel object model
• Adding control statements
• Tin học văn phòng
• Quản trị mạng
• Cơ sở dữ liệu
• Công nghệ thông tin
• Tin học
• Microsoft Access 2010
• Microsoft Powerpoint
• Microsoft Word
• Microsoft Excel
• Managing Macros
• Financial modeling
• Lecture Financial modeling
• Asset expected return
• Advanced excel awesomeness
• Web queries
• Array functions
• thủ thuật hệ điều hành
• tìm hiểu hệ điều hành
• thủ thuật windows
• lập trình windows
• lập trình ứng dụng
• lập trình máy tính
• thủ thuật lập trình
• mẹo hay cho lập trình
• bí quyết lập trình