Find Detailed Properties

  • Having worked with VBA for several years, it's hard to believe I've never got around to asking this question before, but here goes.

    What I'm looking for is the detail around properties I look up in the Object Model. For example, the Range object has the property Borders, and there's generally an example that shows a bit more of the details of the property (e.g., Borders(xlEdgeBottom), then .LineStyle = xlContinuous, Weight = xlThin, ColorIndex = 3. What I'm trying to figure out is where to find ALL the parameters like LineStyle and ALL the options like xlContinuous. I've seen such tables before, but just can't figure how to get to them.

    Any and all help will be greatly appreciated. Thanks.

  • Re: Find Detailed Properties

    while writing code you can use ctrl + SPACE to get the list object properties of the object...

  • Re: Find Detailed Properties

    That's good to know, but there's no connection between the elements in the dropdown and the properties they relate to. Maybe I'm just lazy, but what I'd really like to find is a list of properties with the elements related to them

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!