Page 232 - Trackpad 402_Class-X_Final
P. 232

Step 3:  Select M1 Macro created earlier. Click on Edit button. This will open a code window as shown below:

























        You will see that the code begins with sub followed by a macro name and ends with End Sub.


                                1. Type DISPLAYCONTENT() in the cell and see whether you get the answer or not.
                                2. Using macro tool try to record a macro.
                                3. After clicking on Merge document which dialogue box opens up.
                 uiz Bee        4. Why do we compare documents?




        Using a Macro as a Function

        Macros in OpenOffice Calc can be used to create user defined functions. Functions created are not case sensitive. The
        steps to create a simple macro function are as follows:
        Step 1:  Create a new worksheet.
        Step 2:  Click on Tools menu and then select Macros option. A submenu appears on the screen.
        Step 3:  Click on Organize Macros and then OpenOffice Basic.
        Step 4:  Select any macro name and click on Edit button.
        Step 5:  In the Macro code window, create an empty line before Sub and End Sub. Write the given code:
                Function Displaycontent()
                Displaycontent()=”Macros are interesting”
                End Function
                The code window after the given code is entered is shown below:

























          232   Trackpad Information Technology-X
   227   228   229   230   231   232   233   234   235   236   237