Professional Excel Development [Electronic resources] : The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA®

Stephen Bullen, Rob Bovey, John Green

نسخه متنی -صفحه : 225/ 209
نمايش فراداده

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]

Icon property procedure

icon/mask method

icons

loading custom icons from files

bitmaps 2nd

Icons.res resource file

ICountVisibleWorkbooks procedure

ID property

ID/Tag combination

IfError automation add-in

IFERROR UDF

IgnoreOtherApplications

Immediate window

Debug.Print statement

executing code

implementing

custom interface 2nd

single exit points

implicit agreement

implicit interfaces

importing

text files

XML data 2nd

XML data files

in-process communication

indexes

unique

indexes (Help files)

infinite loops

protecting agains

initialize

Initialize event 2nd

INSERT statement (SQL)

inserting data

installation application

installing

COM Add-ins 2nd

HEML Help Workshop

installation location

installation mechanisms

installation requirements

instances

handling

application availability

creating new instances

multiversion support

referencing existing instances

tidying up

instantiate

instantiating

global class variables

instantiation

auto-instantiation

IntegralHeight property

setting to False

intellectual property

IntelliSense

interfaces

CClassName

custom

defining

implementing 2nd

use of 2nd

default

implicit

improving robustness

IProgressBar interface 2nd

polymorphic classes 2nd 3rd

Progress Bars

progress bars

intermediate tables

internal code comments

intrusive validation

IPlugInForm Interface class

IProgressBar interface 2nd

IsAddin property

IsEnabled setting

IsMenubar setting (CommandBar objects)

IsNumeric() function

ISortab leObject interface

IsTemporary setting

iterating

through a collection of different object types