Contents

OVERVIEW... 4

DEVELOPER TAB. 6

BASIC RULES. 8

VISUAL BASIC EDITOR. 10

CREATING A CUSTOM FUNCTION- DOUBLE VALUE. 12

CREATING A CUSTOM FUNCTION- Sales Variance PY to CY. 14

DOCUMENTATION.. 20

SAVING CUSTOM FUNCTIONS. 20

LET’S TRY-IT- ON YOUR OWN REVIEW... 25

Solution. 26

CREATING A CUSTOM FUNCTION – IF STATEMENT. 27

COMPARING SYNTAX. 30

EDITING AND DELETING A CUSTOM FUNCTION.. 32

EDIT. 32

DELETE. 33

ADD-INS. 33

CONCLUSION.. 34

REVIEW QUESTIONS. 35

SOLUTIONS TO REVIEW QUESTIONS. 37

APPENDIX A. 40

APPENDIX B. 41

CHANGE MACRO SETTINGS. 41

USING DIGITAL SIGNATURES. 44

TROUBLE SHOOTING.. 44

GLOSSARY. 45

CPE EXAM ASSESSMENT. 47