vba - Why doesn't VBE.ActiveCodePane.CodeModule work when the VBE (code window) isn't open?

Question

Create a form that runs the following code.

MsgBox (VBE.ActiveCodePane.CodeModule)

And this message appears.

Now save, close, and reopen the database, and see this message:

Run-time error '91': Object variable or With block variable not set

If you open the Visual Basic Editor, it runs again. Even if you close the VBE, it still runs.

But when you close the whole application and reopen it, leaving the VBE closed, you get the error.

Why? What's going on here?

Answer 1

You reference the active pane object. The object isn't set until a pane gets activated. So before you open the VBE, the object is not set yet. Once you close the VBE, the object remains, so you can still reference it.

To get a handle to the ActiveCodepane object, without opening the VBE, is by activating a VBComponent, like this:

VBE.ActiveVBProject.VBComponents("Module1").Activate

You can activate any VBComponent like this.