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]
packaging applications installation location installation mechanisms installation requirements 2ndpanels General Options panel Parameter setting (CommandBarControl objects) Pascal strings 2nd paste Paste Special Bar COM Add-in Paste Special Bar VSTO add-n Paste Special Command Bar PerfMon utility 2nd PerfMonStopMonitoring call performance 2nd controlling applications from Excel macro-optimization best routines binary search nested loops QuickSort routine sort and scan SORTSEARCH_INDEX udt micro-optimization Excel 2nd 3rd VBA 2nd 3rd optimization 2nd 3rd PerfMon utility 2nd PerfMonStopMonitoring call permanent assertions permanent menus (COM Add-ins) 2nd pictures pivot caches pivot tables 2nd calculated fieldspixels converting to points finding size of plot datapoints converting pixesls to polymorphic classes 2nd 3rdpopulating PowerPoint presentation from Excel data Wrd template from Excel data populating a Word document from Excelpopup menus userforms Position setting (CommandBar objects)positioning controls (userforms) 2nduserforms next to a cell power usersPowerPoint charts Slide object using Excel data prefixes primary axis primary keys natural vs. artificial 2nd procedure error handlers 2nd procedure-level code comments procedures creating PerfMon calls trivial validating arguments before use ProExcel VSTO template 2nd CExcelApp class CThisWorkbook class MStandardCode module VSTOHooks.vb file ProExcel VSTO templateCSheet1 class program columns program rowsprogramming code coments code reusedebugging
[See debugging] defensive coding naming conventions descriptive names Excel UI making exceptions prefixes sample VB6 ActiveX DLL projects 2nd 3rd 4th 5th 6th 7th displaying VB6 form in Excel 2nd 3rd 4th VBA progress bars 2nd Progress Bars ProjectConsultantRole tableproperties userformsproperty procedures class modules Protection setting (CommandBar objects)provicers Microsoft Jetproviders SQL Sever providers (OLE DB) public scope |
لطفا منتظر باشید ...
