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
   169   170   171   172   173   174   175   176   177   178   179