Page 174 - IT_V1.0_Class10
P. 174
7
6
Step 8: Type the name of the module.
Step 9: Click on the OK button. The BASIC Macro dialog box will appear.
Step 10: Type the name of the macro in the Macro Name text box.
Step 11: Click on Save button. The macro will be created.
10
8
9
11
To use the created macro for sorting data in ascending order, let’s try in a new set of data.
Step 1: Enter the data to be sorted.
Step 2: Select the cells containing data.
Step 3: Click on the Tools menu.
Step 4: Select the Macros option. A sub-menu
appears on the screen.
7
Step 5: Select the Run Macro option. The
Macro Selector dialog box appears on
the screen.
6
Step 6: Select the module containing the desired
macro.
Step 7: Select the macro created for sorting data.
Step 8: Click on the Run button. Sorted data
appears on the screen.
8
172 Information Technology Play (Ver 1.0)-X

