Page 222 - IT 402 v2.0 class 10
P. 222

Running a Macro

        We can use following three methods to run a macro:
        I.   Tools   Macro   Run

        II. Use a Push Button
           Steps are as follows:
           Step 1:   Select the View   Toolbars   Form Controls option.

           Step 2:   Drag a Push Button control in any blank cell.
           Step 3:   Right-click on the button and select the Control option. The Properties: Push Button dialog box
                   appears.
           Step 4:   Click on the Events tab.

           Step 5:     Click on the ellipse (…) button in front of the Mouse button pressed event. The Assign action
                   dialog box appears.

                                                                            4













                                                                            5



           Step 6:   Click on the Macro button. The Macro Selector dialog box appears.




                                                                                       6


















           Step 7:   Select the macro from Module   Library node.
           Step 8:   Click on OK button. The Assign action dialog box re-appears.

           Step 9:   Click on OK button.
           Step 10:  Using the General tab, give a name to the button and keep design mode ON
           form controls.





         220       Touchpad Information Technology-X
   217   218   219   220   221   222   223   224   225   226   227