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

