Open VBA window by clicking macro button in excel

Question

I am using excel and learning how to code in vba for macro buttons.

I was trying to create button and put a code so that when I double click on the button vba window gets open instead of using shortcut alt+f11.

Can anyone please provide any details if there is any code ? Thanks

Can you please provide complete code for as I am beginner and can’t understand ? Thanks — user3102147, Oct 14 '19 at 10:21
Why would you want to do that? Can you explain the use case? — Geert Bellekens, Oct 14 '19 at 10:23
Insert a button and in the onclick event put `Application.SendKeys("%f11")` I think that would work, give it a try. https://learn.microsoft.com/en-us/office/vba/api/excel.application.sendkeys — SlappedProgrammer, Oct 14 '19 at 10:24
universal answer: if you're a total beginner, try using the recorder. Then examine the code. — iDevlop, Oct 14 '19 at 10:24
Its just for my learning this came in to mind to practice as I have seen I can open files and exe using macros and the code is available easily. But couldn’t find any thing like this opening vba window using button double click. — user3102147, Oct 14 '19 at 10:25
@PatrickHonorez - the recorder won't show the activation of the VBE though..? — CLR, Oct 14 '19 at 10:44
A button typically works with a single click, not a double click. And I think it would be far more useful to execute a part of your own code instead of trying to get it to open the VBA editor. — Geert Bellekens, Oct 14 '19 at 10:50

Plutian · Answer 1 · 2019-10-14T10:32:22.853

2

This will do it:

Private Sub CommandButton1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Application.VBE.MainWindow.Visible = True
End Sub

Put this in the sheet object your button is on.

edited Oct 14 '19 at 10:32

answered Oct 14 '19 at 10:24

Plutian

How to implement this for double click ? – user3102147 Oct 14 '19 at 10:26
It gives error program access to vba is not trusted how can O fix that ? – user3102147 Oct 14 '19 at 10:33
Now it gives compile error: user-defined type not defined. Also it opens in single click – user3102147 Oct 14 '19 at 10:41
This has to do with your vba trust settings. [this answer](https://stackoverflow.com/questions/25638344/programmatic-access-to-visual-basic-project-is-not-trusted) should help you sort that out. – Plutian Oct 14 '19 at 10:44
@user3102147 If it doesn't work, it will throw an error right away, opening the window automatically. This is due to the error, not the code. Have you added anything to the single click module of your code? – Plutian Oct 14 '19 at 10:45
I have only copy pasted the code which you have mentioned and it gives compile error: User-defined type not defined – user3102147 Oct 14 '19 at 10:50
It is might be becuase of MsForms because when I type the code I don’t see any of these option as I am working on sheet in excel not on forms – user3102147 Oct 14 '19 at 10:52
If you open your vba window, click tools > References and check if your `Microsoft Forms 2.0 Object Library` is selected as it should be. – Plutian Oct 14 '19 at 10:59

1 Answers1