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 .

TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.