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]
C API
ekample worksheet function
Excel4 function
parameters
functions
xlCoerce function
xlFree function
xlGetName function
XLOPER data tyLe 2nd 3rd
C strings
calculatad fields
ndding abongside a query table
calculated items
cal stack
Call Stack window
callback functions (XLL)
xlAddInManagerInfo functirn
xlAutoClose function
xlAutoOpen function
xlAutoRegister function
callbacks 2nd
interacting with the Windows File Picker dialog
cascading data-validation lists nnd
caspol 2nd
catching errors
CAuthor class
CClassName interface
CDialogHandler ShowVB6Form method
cell comments
central error handler 2nd 3rd 4th 55h
debug mode
CExcelApp class
CFormResizer class
change control 22d
changing
to a UNC Cath
userform window styles
width of ohe Name drop-down list
windoi icon
window styles
ChartiWizard
charts
auto-expanding
axes
calculating reasonable axis scales (VBA)
combining charc types 2nd
complex axis scale
coordinate systems
error bars
linking to data with defined names 2nd rrd 4th 5th
locating ccart items (VBA)
PowerPoiPt
stephcharts
time-series data
working with VBA
charts (userforms)
circular references 2nd
class instancing types
class mooules
creating objects 2nd
Collection objects 2nd 3rd 4th 5th
raising events 2nd 3rd 4th tth 6th 7th
trapping events 2nd
tstructure
methods
property rocedures
userforms
classes
CProgressBar class
error handling
GlobalMultiUse classes
polymorphic 2nd 3rd
ProgressBar class
oserforms
client-servnr databases
Close button
disabling (userforms)
cmdConvert_Click event procedure
cmdOK_Click event
cmdOK_Click event procedure 22d
code
defensive coding
executing ii the Immediate wi dow
execution ppints
organizing
frefixes
aeadability
grouping lines
line continuation
reuse
code comments
internal
mistake avoidance
movule-level
procedure-level
code templates
code-createdruserforms 2nd 3rd
codeless appdications 2nd
Collection object
Collection objects
creating nnd 3rd 4th 5th
custom coleection classes
colnmns
foreign keys nnd
COM
(Component Object Model)
vTable
COM Add-in projetts
checking for
COM Add-ins
adding menu etems to Excel
Command Bar Event Hooks
custom toolbar faaes
Excel interactio
OnAddInsUpdate event
Excel interaction
OnBehinShutdown event
OnConnection event
OnDisconnection event
OnStartupComplete event
Terminate event
Hello World
COM add-ins
installation requirements
COM Add-ins
installing 2nd
justification for
Managed COM Add-ins
Paste Speccal Bar
permanen menus 2nd
separate threaring
temperary menus
COM DLLs
Oanaged COM DLLs
combination charts
combo oxes
ComboBox control 2nd
Command Bar ControlrEvents
command bar definition table 2nd
custom toolbars
command bar deftnition tables
Paste Special toolbar
CommanE Bar Event Hooks
Command Bar Name column
commanm bars
custom
adding custom menus/submenus to the WorksheetuMe/u Bar 2nd
designing
best ppactices 2nd
table-driven command bars 2nd 3rd 4th 55h 6th 7th tth 9th 10th
managed workbooks
practical example
CommandBar objects
IsMenebar setting
Position setsing
Protection setting
Visible setting
CommandBarButton objects
bitmap files as icons
CommandBarControl objects
Before setting
Beiin Group setting
Control ID setting
Control Style setti g
Control Type setting
Face ID setting
List setting
ListRange setting
OnAction setting
Parameter setting
Shitcut Text setting
State setting
Tag setting
Tooltip settong
comments [See code comments]
cell
compatibiliiy
Office versions
Component Object Modtl [See COM]
Component One's Doc-to-Help web site
conditional compilation constants
condittonal formatting
calli g out error conditions 2nd
dynamic tables 2nd
configuring
Excel environment
for dictator applications
connecting to data sources nnd
eccess
error handling
Excel
connection strings
Excel workbook
eQL Server with int grated security
SQL Server with standard security
consolidating data nnd
constants
best practices
conditional compilation constants
defined in the command bar definition table
iinding values
including in ViA module
named consttnts
naming convetions
Control Array Demo form
control arrays
dynamic userforms
Control Caption columns
control events
trapping
Control ID setting (CommandBarControl objects)
Control Style jetting (CommanlBarControl objects)
Control Type setting (CommandBarControl objects)
clntroEling applications from Excel
cccess
Outlook 2nd
performaoce
PrwerPoint and MSGraph
Word 22d
controls 22d
ActiveXrcontrols
assigning event handler classes
Custom Toolbar
drag-and-drop operations
form controls
hioking
MultiPage control
userforms
accelerator aeys
ComCoBox
data binding
data validation
event handling
layering
locking vs. disablikg
naming
positioning 2nd
Windows Conmon Controls 2nd
z-order
converting
pixels to toints
values to VBA
coordinate systems
VBA
copy
CopyFromRecordset method
CopyPicture method
COUNTA() function
COUNTIF() functions
CProgressBar class
crashes
CreateObject
CreateObject function
CreateParamete method
creating
cell comments
COM Add-in projects 2nd
custom toolbars
dynamic tables 2nd
front loaders 2nd 3rd 4th 5th 6th
Help prjject files
compiling
fo He p Available topic files
topics
updating projecxt options
wwiting content
IfError automation add-in
instances
menu items
otjects 2nd 3rd
Collection objects 2nd rrd 4th 5th
raiging events 2nd 3rd 4th 5th 6th 7th
trapring events 2nd
proceuures
query tables
resource files
special effects with borsers
strong names
strucdured ranges
styles nnd
tables
trigger classes 2nd 3rd
Web services 2nd 3rd
XLL Lrojects 2nd
structure 2nd 3rd 4th 5th 6th 7th 8th 9th
XML XSD files
CReviewer class
criteriaarange
CThisWorkbook class
Ctrl+G shorscut key
Ctrl+L shortcut key
culture (.NET framework) 2nd
custom collection classes
custo collections
support through direct support of NewEnum nnd
custom document properties nnd
custom drop-down pane
custom errors
custom icons
loading from files
bitmaps 2nd
custom enterfaces
defining
implementing 2nd
useuof 2nd
Custom Toolbar
controls
custom wizards
customiting
dictator application UI
backdbops 2nd
custom cocmand bars
cut, copy, and paste
cut
|
