Request Visual Basic general object:action commands

[RGillespie]

Does anyone have a list of basic/general Visual Basic object:action commands (e.g., Range("x:x").Select)?

[Damon Ostrander]

Hi RGillespie,

Firstly, these are not actually Visual Basic commands. They are part of the Excel Object model. If you were working with VBA in Word, PowerPoint, Access, etc., you would be working with the same VBA programming language but with different object models. Every application's "object model" defines its objects, and all objects can have Properties, Methods, and Events. As a result, the list of possible methods, properties and events is HUGE (many thousands). If you want a high-level view of the Excel object model, go to the topic Microsoft Excel Objects in the VBA helps. Note the red arrows that you can click on to further expand the object model.

If you want to focus on a single object, such as the Range Object (a worksheet cell or collection of cells) simply go to the Range Object topic in the VBA helps. Then peruse the Range Object's Properties and Methods (Range objects don't have any Events). Be forewarned: the Range object has a VERY rich object model--it has dozens of properties and methods.

I hope this helps.

Damon

[RGillespie]

Thanks Damon!! I'll check this out.