Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z] satellite DLL SaveSettingsaving application versionsschema mapping to worksheets schema definition files (XML)scope defined names error handling 2nd variables 2nd screen resolutionscreen resolutions userform concerns scroll regions (dynamic userforms) second normal form secondary axissecurity checking network groups 2nd COM Add-ins Excel 2nd macro security 2nd VSTO VSTO security model 2nd caspol 2nd strong names 2nd SELECT statement (SQL) self-automated workbooks 2nd SendKeys separate threading Series() function Set Next Statement command Set Transparent Color control cursorsetting basic watches break points SetUserformAppearance procedure shapes sharing command bars (managed workbooks) 2nd SHBrowseForFolder function sheet-based UIshortcut keys debugging 2ndshortcut keys (debugging) Step Into command Step Out command Step Over command Step to Cursor command Shortcut Text setting (CommandBarControl objects) ShowDLLMessage procedure ShowWindowsInTaskBarshutdown add-ins dictator applications Debug Mode 2nd handling crashes storing/restoring Excel settings 2nd ShutdownApplication procedure single exit point principlesize converting pixels to points device contextssizing userforms sorting routines SORTSEARCH_INDEX udtsource data defined names special folders 2ndsplash screens showing at startup splitter bars Spy++ utilitySQL (Structured Query Language) data retrieval DELETE statement further resources 2nd INSERT statement SELECT statement UPDATE statement Standard EXE (VB6)startup add-ins dictator applications Debug Mode 2nd storing/restoring Excel settings State setting (CommandBarControl objects)statements Resume statements step charts Step Out command Step Over command step through code Step to Cursor command stepping into codestong names trustingstorage resource files (VB6)storing toolbar customizationsstrings byte-counted strong names creating trustingstructureclass modules methods property procedure dictator applications front loader applicationsStructured Query Language [See SQL] structured ranges creating Style Includes optionstyles (windows) adding Style drop down to the toolbar advantages creating 2nd modifyingwindows userforms Sub Main procedure Sub New () procedure subroutines subset userforms subtiers sum of digits SUMIF() functions |