Making Branching

VBA supports If...Then and If...Then...Else or Elself structures, very similar to the Excel worksheet function IF. In addition, VBA provides the Select Case decision structure, similar to the ON value GOTO statement in BASIC. 

Else or Elself structures are also possible. For example  

TestExpression is evaluated and used to direct program flow to the appropriate Case. ExpressionListN can be a single value, a list of values separated by commas or a range of values. The optional Case Else statement is executed if TestExpression doesn t match any of the values in any of ExpressionListN. 

Note that a range of values is indicated by using the To keyword. 

Select Case TestExpression Case ExpressionListI statements Case ExpressionList2 statements Case ExpressionListS statements Case Else statements End Select 

Select Case TestExpression Case ExpressionListl statements 

---

Branched cydodextrins are also used to increase the solubility of complexes. Two methods are used to make branched cydodextrins, an enzymic method and a pyrolytic method. In the enzymic method, a starch debranching enzyme, such as pul-lulanase, is added to a solution of cyclodextrin and a large excess of D-glucose or maltose to force the reaction to proceed in the reverse direction, i.e. to add rather than remove a branch.69 Since the equilibrium favors the debranching reaction, yields are low and the product typically contains —15% branched cyclodextrin and —85% glucose or maltose. Purification is difficult because of the high solubility of both the glucose or maltose and the branched cyclodextrin, but much of the unreacted cyclodextrin can be removed by crystallization. 

Many researchers have attempted to make branched polystyrene in continuous bulk radical polymerization processes. Approaches involving the addition of additives to the polymerization process which lead to branching inside the polymerization reactor always lead to gel problems. Examples include addition of divinylmonomer [4], vinyl peroxides (e.g. I) [5,6], branched peroxides (e.g. II) [7], vinyl-functional chain transfer agents (III) [8], and the use of addition-fragmentation chain transfer agents that lead to the formation of polystyrene macromonomers (Figure 24.3) [9]. 

Both kinds of macro can incorporate decision-making, branching, looping, subroutines and many other aspects of programming languages. 

Leaves distorted, orange-yellow spots on leaf undersides. Cause Rust. This fungus produces orange pustules, distorting the leaves and making branch tips swell. Rust usually doesn t harm the tree much, except for detracting from the appearance. Clean up and destroy fallen leaves and branches in autumn. To prevent the spread of mild infections, spray leaves with sulfur early in the season. 

The incorporation of polar side groups into the rubber structure imparts a dipolar nature, which provides oil resistance. Oil resistance is not found in rubber containing only carbon and hydrogen atoms (e.g. natural rubber). On the other hand, by making branched rubber chains rather than linear ones, low viscosity polymers for solution applications are obtained. 

In reality (e.g., the assessment of safety cases), decision problems tend be structured certain factors may feed-in to each other, and can form more complex, hierarchical belief structures. ER [2] is an extension of DS-theory that enables the aggregation of belief functions, where the factors are arranged in a hierarchical structure. The root-node represents the final decision one wishes to make. Branch nodes represent contributory factors. Branches can be given different weights, indicating the extent to which they contribute to the overall decision. Leaf-nodes represent points at which one can present ones own belief functions. ER then provides the mathematically sound basis by which to combine the belief-functions provided in the leaf-nodes, and to propagate them up to the root. 

Two intermediates (64 R=MMTr or pixyl) have been synthesised and used to make branched ribonucleic acids, since they permit extension in all three directions. 132 phosphoramidltes of type (65) have been prepared, where the base is also protected by a group removable by reductive cleavage. 133... 

Program control statements include those for decision making (branching) and for looping. Many such statements available in VBA are discussed below. Ones less frequently used (or ones that are repetitious) are not covered. 

---