Excel 2010 Bible

Chapter 39: Introducing Visual Basic for Applications 819 .VerticalAlignment = xlCenter .WrapText = False .Orientation = xlHoriz ...

Part VI: Programming Excel with VBA 820 For Each cell In InputRange If cell.HasFormula Then OutputSheet.Cells(OutputRow, 1) = “’ ...

Chapter 39: Introducing Visual Basic for Applications 821 As macros go, this example is okay, but it’s certainly not perfect. It ...

...

823 CHAPTER Creating Custom Worksheet Functions IN THIS CHAPTER Overview of VBA functions About function procedures Function pro ...

Part VI: Programming Excel with VBA 824 An Introductory Example Creating custom functions is relatively easy after you understan ...

Chapter 40: Creating Custom Worksheet Functions 825 the function from the list, you can then use the Function Arguments dialog b ...

Part VI: Programming Excel with VBA 826 If you work with this function, you might notice a problem if the argument is non-numeri ...

Chapter 40: Creating Custom Worksheet Functions 827 Note Step 3 is very important. If you put a function procedure in a code mod ...

Part VI: Programming Excel with VBA 828 Using custom functions in a worksheet formula You use a custom function in a worksheet f ...

Chapter 40: Creating Custom Worksheet Functions 829 l (^) Some functions have a fixed number of required arguments (from 1 to 60 ...

Part VI: Programming Excel with VBA 830 For example, if you enter this formula, Excel will “speak” the contents of cell A1 whene ...

Chapter 40: Creating Custom Worksheet Functions 831 A better solution is to use a lookup table function to compute the commissio ...

Part VI: Programming Excel with VBA 832 Function Commission2(Sales, Years) ‘ Calculates sales commissions based on years in serv ...

Chapter 40: Creating Custom Worksheet Functions 833 Wouldn’t it be easier if Excel had a function named TopAvg? For example, you ...

Part VI: Programming Excel with VBA 834 l (^) Test the procedure by calling it from a Sub procedure. Run-time errors display nor ...

Chapter 40: Creating Custom Worksheet Functions 835 FIGURE 40.3 Entering a description for a custom function. This description a ...

Part VI: Programming Excel with VBA 836 FIGURE 40.4 Using the Function Arguments dialog box to insert a custom function. Learnin ...

837 CHAPTER Creating UserForms IN THIS CHAPTER Why create UserForms UserForm alternatives Creating UserForms: An overview UserFo ...

Part VI: Programming Excel with VBA 838 This macro is useful, but it can be improved. For example, the macro would be more helpf ...