How To Open VBE UserForm Window (With Macro)?

[indi visual]

I've tried these:

OptionExplicit

Sub OpenMacroNameDirectly

With Application

.Goto "MacroName"

End With

End Sub

''''''''''''''''''''''''''

'Application.VBE.MainWindow.Visible = True

'Application.VBE.ActiveCodePane.Show


They work like a charm, but not with getting in UserForm code (only standard modules).

My guess is because they're all private subs, any ideas are much appreciated as always.


Trying to get directly into the actual code part for userform, not the userform itself.

 

[Luke M]

Sub OpenMacroNameDirectly()

With Application.VBE

.ActiveVBProject.VBComponents("UserForm1").CodeModule.CodePane.Show

End With

End Sub


Curious, why do you want to show the code?

 

[indi visual]

I wanted to have a quick shortcut button to jump directly in there.


I make a lot of mistakes : )