Running a Sub Procedure

Here are some (but not all) of the ways to run a command macro from the Macro dialog box, as described in this chapter by means of a shortcut key, as described in this chapter by means of a custom menu command, as described in Chapter 18 by means of a custom button on a toolbar, as described in Chapter 19 by means of a button on a worksheet, as described in Chapter 8 as a subroutine called by another macro, as described in Chapter 15 

---

To enter a description by means of VBA code, type and run a Sub procedure similar to the one shown in Figure 17-6. 

Initially, your custom function will be located in the User Defined category in the Paste Function dialog box. You can specify the category in which the function will be located, by typing and running a Sub procedure similar to the one shown in Figure 17-7. The category values are listed in Appendix D. 

Chapter 13 provided an introduction to Sub procedures and Function procedures. By now it should be clear that a Sub procedure (a command macro) is a computer program that you "run" it can perform actions such as formatting, opening or closing documents, etc. A Function procedure (a user-defined fimction) is a computer program that calculates a value and returns it to the cell in which it is typed. A Function procedure cannot change the worksheet environment ( e.g., it can t make a cell Bold). 

If you run the preceding Sub procedure, you will find that cells El through E10 will all contain 11, the first element of the array. However, if you write the array to a row of cells instead of a column, thus ... 

When you use Paste Function to enter a function, the function s description appears at the bottom of the dialog box. For a custom function, the default description is "Choose the Help button for Help cn this function and its arguments", but you can provide a custom description for your custom function. There are two ways to do this you can use the Macro dialog box (normally used only for Sub procedures), or you can write and run a simple one-line VBA Sub procedure. Either way, the description becomes part of Excel and does not need to be entered each time you start Excel. 

In previous chapters you learned how to create useful Sub procedures. You may find that you use a particular macro so often that it would be more convenient to have it on one of Excel s drop-down menus, rather than having to "run" it by means of the Run command from the Macro menu. Running a command macro by means of an Excel menu command makes the custom command accessible to Excel users who are not familiar with the use of macros. 

Analysis of Research Proposals. The Army Medical Reseetrch and Development Command supports research in the directed synthesis of screening candidates. Twice yearly the Division of Eiqperi-mental Therapeutics reviews synthesis proposals. The proposed structures in each proposal are entered into the data base in the "XR" series and are also entered as identity searches to determine whether or not the compounds are already on hetnd cuid to identify duplication among the proposals. In addition, substructure searches for the major classes of compounds proposed are also run. Matches from both the identity eind sub-structure searches are then used to query the biology auid inventory files. The reviewer is presented with a report sequenced by proposal number providing him with all available information on the availability and activity of all specific compounds emd classes of compounds in each proposal. A similar procedure is used by contract monitors to review progress on synthesis contracts cind to prevent duplication of effort. 

To allow a full evaluation, however, it is necessary to consider not only the experimental data for the butane-NOx system, but also the NOx photo-oxidation runs for intermediate products, MEK, CH3CHO and HCHO. The aim of the mechanism refinements for butane degradation, therefore, was to provide an adequate, self-consistent description of all these systems, whilst simultaneously identifying any required modifications to the auxiliary mechanism parameters. Mechanism testing and refinement was therefore carried out by an iterative procedure, considering butane photo-oxidation and each of the sub-systems in turn. The adapted version of MCM v3, resulting firom identified modifications, is denoted MCM v3a throughout this article. 

A fully decentralized multi robot algorithm is designed exploiting lEKF. Each robot in the team runs its own localization procedure and exchanges pose information with the robots in the surrounding area. The state transition model for each sub-filter is given by ... 

---