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] validating data userform controlsvalues atomic converting to VBAvariables best practices 2nd 3rd lvalue member variables naming conventions scope 2nd storing handles variant arraysVB.NET creating Web services 2nd VB6 (Visual Basic 6) activeX DLL projects 2nd code protection complex case two-way communication 2nd 3rd custom collections displaying a VB6 form in Excel 2nd 3rd 4th OOP resource files simple case one-way communication 2nd taking advantage of VB6 forms 2nd 3rd 4th 5th 6th 7th 8th control arrays 2nd 3rd 4th 5th referencing Excel Standard EXEVB6 EXE automating Excel 2nd 3rd 4th 5th 6th VB6 EXE front loaderVB6 front loaders creating 2nd 3rd 4th 5th structure Sub Main procedure VB6 Resource Editor VBA advanced filtering charts caclulating reasonable axes scalses Collection objectdebugging break points Step Out command Step Over command step through code Step to Cursor command stepping into code developers displaying Help files 2nd error handling [See error handling] hybrid VBA/VSTO solutions 2nd 3rd locating chart items migrating to VSTO modifying worksheet UI naming conventions Object Browserprogramming best practices 2nd 3rd 4th 5th self-automated workbooks 2nd Stop statement UDF problems UDFsVBA applications code validation VBA References dialogVBE (Visual Basic Editor) Add-in Manager dialog conditional compilation constants VBE Error Trapping settingVBE Object Browser msoControlType enumeration members VBE Tools Control Nudger toolbar VBIDE VeriSignversion checks dictator applicationsvirtual function table [See vTable] Visible setting (CommandBar objects)Visual Basic Editor [See VBE] Visual Studio Tools for Office (VSTO) Visual Studio.NET including XSD files in projects VSTO application links functional gaps global solutions 2nd hybrid VBA/VSTO solutions 2nd 3rd managed Excel add-ins managed workbooks default template Hello World 2nd ProExcel template 2nd 3rd 4th 5th 6th sharing command bars 2nd migrating from VBA Office versions overview 2nd security security model 2nd caspol 2nd strong names 2nd VSTO (Visual Studio Tools for Office) VSTOHooks.vb file vTable |