Working with Code Windows

When you become proficient with VBA, you'll be spending lots of time working in code windows. Each object in a project has an associated code window. To summarize, these objects can be

■ The workbook itself (ThisWorkbook in the Project Explorer window)

■ A worksheet or chart sheet in a workbook (for example, Sheet1 or Chart1 in the Project Explorer window)

■ A class module (a special type of module that lets you create new object classes)

0 0

Post a comment