Advanced Excel Macros and VBA Glossary

A

• accelerator key in Advanced Excel Macros and VBA
• Accessing external data in Advanced Excel Macros and VBA
• ActiveX controls in Advanced Excel Macros and VBA
• Add-ins in Advanced Excel Macros and VBA
• Advanced filtering in Advanced Excel Macros and VBA
• Advanced sorting in Advanced Excel Macros and VBA
• API calls in Advanced Excel Macros and VBA
• Application object in Advanced Excel Macros and VBA
• Arrays in Advanced Excel Macros and VBA
• Automation in Advanced Excel Macros and VBA

B

• background color in Advanced Excel Macros and VBA
• Binary file I/O in Advanced Excel Macros and VBA
• Bitwise operations in Advanced Excel Macros and VBA
• bound in Advanced Excel Macros and VBA

C

• Call statement in Advanced Excel Macros and VBA
• Cell comments in Advanced Excel Macros and VBA
• Cells in Advanced Excel Macros and VBA
• Charts in Advanced Excel Macros and VBA
• Class hierarchies in Advanced Excel Macros and VBA
• Class inheritance in Advanced Excel Macros and VBA
• Class modules in Advanced Excel Macros and VBA
• clear in Advanced Excel Macros and VBA
• client region in Advanced Excel Macros and VBA
• Clipboard operations in Advanced Excel Macros and VBA
• Code optimization in Advanced Excel Macros and VBA
• Collections in Advanced Excel Macros and VBA
• Command bars in Advanced Excel Macros and VBA
• Command buttons in Advanced Excel Macros and VBA
• Conditional compilation in Advanced Excel Macros and VBA
• Conditional formatting in Advanced Excel Macros and VBA
• Conditional formatting rules manager in Advanced Excel Macros and VBA
• Constants in Advanced Excel Macros and VBA
• context ID in Advanced Excel Macros and VBA
• control group in Advanced Excel Macros and VBA
• Control structures in Advanced Excel Macros and VBA
• control tip in Advanced Excel Macros and VBA
• cursor in Advanced Excel Macros and VBA
• Custom functions in Advanced Excel Macros and VBA
• cycle in Advanced Excel Macros and VBA

D

• Data analysis toolpak in Advanced Excel Macros and VBA
• data format in Advanced Excel Macros and VBA
• Data mining in Advanced Excel Macros and VBA
• data source in Advanced Excel Macros and VBA
• Data types in Advanced Excel Macros and VBA
• Data validation in Advanced Excel Macros and VBA
• Date and time functions in Advanced Excel Macros and VBA
• Debug.Print in Advanced Excel Macros and VBA
• Debugging in Advanced Excel Macros and VBA
• Delegates in Advanced Excel Macros and VBA
• Dictionary object in Advanced Excel Macros and VBA
• Directives in Advanced Excel Macros and VBA
• dominant control in Advanced Excel Macros and VBA
• drop source in Advanced Excel Macros and VBA
• Dynamic arrays in Advanced Excel Macros and VBA
• Dynamic charting in Advanced Excel Macros and VBA

E

• Early binding in Advanced Excel Macros and VBA
• enumerated constant in Advanced Excel Macros and VBA
• Error handling in Advanced Excel Macros and VBA
• Error object in Advanced Excel Macros and VBA
• Event handling in Advanced Excel Macros and VBA
• Events in Advanced Excel Macros and VBA
• External data ranges in Advanced Excel Macros and VBA
• External references in Advanced Excel Macros and VBA

F

• File dialog box in Advanced Excel Macros and VBA
• File I/O in Advanced Excel Macros and VBA
• FileSystemObject in Advanced Excel Macros and VBA
• Financial functions in Advanced Excel Macros and VBA
• Folder object in Advanced Excel Macros and VBA
• foreground color in Advanced Excel Macros and VBA
• Forms in Advanced Excel Macros and VBA
• Function libraries in Advanced Excel Macros and VBA
• Function procedures in Advanced Excel Macros and VBA

G

• Gantt charts in Advanced Excel Macros and VBA
• GetObject function in Advanced Excel Macros and VBA
• grid block in Advanced Excel Macros and VBA

H

• Handling large datasets in Advanced Excel Macros and VBA
• Hide and unhide worksheets in Advanced Excel Macros and VBA

I

• If…Then…Else statements in Advanced Excel Macros and VBA
• Image controls in Advanced Excel Macros and VBA
• In-cell barcodes in Advanced Excel Macros and VBA
• In-Cell editing in Advanced Excel Macros and VBA
• Inheritance in Advanced Excel Macros and VBA
• inherited property in Advanced Excel Macros and VBA
• Input Method Editor (IME) in Advanced Excel Macros and VBA
• InputBox in Advanced Excel Macros and VBA
• Inserting shapes in Advanced Excel Macros and VBA

K

• Keyboard shortcuts in Advanced Excel Macros and VBA
• keyboard state in Advanced Excel Macros and VBA

L

• Late binding in Advanced Excel Macros and VBA
• Line controls in Advanced Excel Macros and VBA
• Linking workbooks in Advanced Excel Macros and VBA
• List boxes in Advanced Excel Macros and VBA
• Loops in Advanced Excel Macros and VBA

M

• Macro recorder in Advanced Excel Macros and VBA
• Macro security in Advanced Excel Macros and VBA
• Menu bars in Advanced Excel Macros and VBA
• Merging workbooks in Advanced Excel Macros and VBA
• Modules in Advanced Excel Macros and VBA
• Multidimensional arrays in Advanced Excel Macros and VBA

N

• Named arguments in Advanced Excel Macros and VBA
• Named ranges in Advanced Excel Macros and VBA
• Namespace collisions in Advanced Excel Macros and VBA
• Namespaces in Advanced Excel Macros and VBA

O

• Object model in Advanced Excel Macros and VBA
• Object properties in Advanced Excel Macros and VBA
• Object-oriented programming in Advanced Excel Macros and VBA
• ODBC connections in Advanced Excel Macros and VBA
• OLE container control in Advanced Excel Macros and VBA
• OLE status code in Advanced Excel Macros and VBA
• OnTime method in Advanced Excel Macros and VBA
• Open method in Advanced Excel Macros and VBA
• Operators in Advanced Excel Macros and VBA
• Option explicit in Advanced Excel Macros and VBA

P

• Page setup in Advanced Excel Macros and VBA
• Parent property in Advanced Excel Macros and VBA
• Password protection in Advanced Excel Macros and VBA
• Performance optimization in Advanced Excel Macros and VBA
• Pivot tables in Advanced Excel Macros and VBA
• PivotCharts in Advanced Excel Macros and VBA
• PivotTable reports in Advanced Excel Macros and VBA
• placeholder in Advanced Excel Macros and VBA
• Progress bars in Advanced Excel Macros and VBA
• Properties in Advanced Excel Macros and VBA
• property page in Advanced Excel Macros and VBA
• Property procedures in Advanced Excel Macros and VBA
• Public constants in Advanced Excel Macros and VBA
• Public variables in Advanced Excel Macros and VBA

Q

• Querying databases in Advanced Excel Macros and VBA
• QueryTables in Advanced Excel Macros and VBA

R

• Range names in Advanced Excel Macros and VBA
• Range objects in Advanced Excel Macros and VBA
• Range referencing in Advanced Excel Macros and VBA
• Reading and writing CSV files in Advanced Excel Macros and VBA
• Reading and writing text files in Advanced Excel Macros and VBA
• Recordset objects in Advanced Excel Macros and VBA
• Reference libraries in Advanced Excel Macros and VBA
• Regular expressions in Advanced Excel Macros and VBA
• RGB in Advanced Excel Macros and VBA
• Ribbon customization in Advanced Excel Macros and VBA
• Run-time errors in Advanced Excel Macros and VBA

S

• Save method in Advanced Excel Macros and VBA
• Scripting runtime library in Advanced Excel Macros and VBA
• Select Case statements in Advanced Excel Macros and VBA
• Set keyword in Advanced Excel Macros and VBA
• Shape controls in Advanced Excel Macros and VBA
• Slicers in Advanced Excel Macros and VBA
• Sorting data in Advanced Excel Macros and VBA
• SQL queries in Advanced Excel Macros and VBA
• SQL server connections in Advanced Excel Macros and VBA
• StatusBar property in Advanced Excel Macros and VBA
• String manipulation in Advanced Excel Macros and VBA
• Sub procedures in Advanced Excel Macros and VBA
• system colors in Advanced Excel Macros and VBA

T

• Tab controls in Advanced Excel Macros and VBA
• target in Advanced Excel Macros and VBA
• Task panes in Advanced Excel Macros and VBA
• Text box controls in Advanced Excel Macros and VBA
• The space between two adjacent grid points. in Advanced Excel Macros and VBA
• To change a setting to “off” or remove a value. in Advanced Excel Macros and VBA
• transparent in Advanced Excel Macros and VBA

U

• unbound in Advanced Excel Macros and VBA
• User forms in Advanced Excel Macros and VBA
• User interface design in Advanced Excel Macros and VBA
• User-defined functions in Advanced Excel Macros and VBA

V

• Variables in Advanced Excel Macros and VBA
• VBA editor in Advanced Excel Macros and VBA
• VBA project in Advanced Excel Macros and VBA

W

• Web scraping in Advanced Excel Macros and VBA
• Windows API calls in Advanced Excel Macros and VBA
• Workbook events in Advanced Excel Macros and VBA
• Workbook objects in Advanced Excel Macros and VBA
• Workbook protection in Advanced Excel Macros and VBA
• Worksheet events in Advanced Excel Macros and VBA
• Worksheet functions in Advanced Excel Macros and VBA
• Worksheet protection in Advanced Excel Macros and VBA

X

• XLM macros in Advanced Excel Macros and VBA
• XML parsing in Advanced Excel Macros and VBA
• XMLHTTP requests in Advanced Excel Macros and VBA

Z

• Zooming in and out in Advanced Excel Macros and VBA