Читать книгу Excel VBA Programming For Dummies - Dick Kusleika - Страница 30

Creating a Macro

Оглавление

In this chapter, you create your first macro. The macro that you create does the following:

 Types your name in a cell

 Enters the current date and time in the cell below

 Formats both cells to display bold

 Changes the font size of both cells to 16 point

This macro won’t be winning any prizes for Most Complicated Macro of the Year, but everyone must start somewhere. (And here’s a secret: The macros you use the most are the simplest ones.) This macro accomplishes all these steps in a single action. As I describe in the following sections, you start by recording your actions as you go through these steps. Then you test the macro to see whether it works. Finally, you edit the macro to add some finishing touches.

Excel VBA Programming For Dummies

Подняться наверх