where can I get a solid understanding of the vba object model and get up to speed with developing VBA code? Also, Years ago as a Visual Basic programmer, when we would type something like 'With Selection." or "Range("a2")." after we typed the "." the objects and properties of the Selection object would automatically display, giving us insight into the hierarchy of the VBA object model. Is this capability available in the VBA module editor and if so, how do we access it. Trying it, it doesn't seem to work.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
working with exel vba object model
- Thread starter Shepherd
- Start date
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Here's a link to the Microsoft pages on the Object Model, you might also want to look into the Object Browser(F2) in the IDE.
P.S. I can see I've ever seen Intellisense work for Selection, think that might have been because the VBE wouldn't know what exactly Selection was - is it a range, a chart, a plane?
P.S. I can see I've ever seen Intellisense work for Selection, think that might have been because the VBE wouldn't know what exactly Selection was - is it a range, a chart, a plane?
Upvote
0
Thank you for your quick response. This gives me some things to look at.
Upvote
0
