Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
I am running XP with Office 2002.
What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
Sub vbe()
Application.vbe.MainWindow.Visible = True End Sub 'Tools --Macro--Security 'Click the Trusted Publisher Tab 'Click Trust access to Visual Basic Project Checkbox 'Click ok "Boog" wrote: I am running XP with Office 2002. What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
That has to be the only combination I didn't try.
Thank you for the prompt solution. Cheers. "Office_Novice" wrote: Sub vbe() Application.vbe.MainWindow.Visible = True End Sub 'Tools --Macro--Security 'Click the Trusted Publisher Tab 'Click Trust access to Visual Basic Project Checkbox 'Click ok "Boog" wrote: I am running XP with Office 2002. What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
You could also use this:
CommandBars("Worksheet Menu Bar").Controls("Tools").Controls("Macro").Controls ("Visual Basic Editor").accDoDefaultAction "Boog" wrote: That has to be the only combination I didn't try. Thank you for the prompt solution. Cheers. "Office_Novice" wrote: Sub vbe() Application.vbe.MainWindow.Visible = True End Sub 'Tools --Macro--Security 'Click the Trusted Publisher Tab 'Click Trust access to Visual Basic Project Checkbox 'Click ok "Boog" wrote: I am running XP with Office 2002. What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
Alt-F11 will also open the VBE, and takes less time than mousing over a button, if your hands are
already on the keyboard.... HTH, Bernie MS Excel MVP "Boog" wrote in message ... I am running XP with Office 2002. What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
Bernie,
I have used Alt-F11 in the past but I usually have the mouse in hand. Thanks to all for their input. "Bernie Deitrick" wrote: Alt-F11 will also open the VBE, and takes less time than mousing over a button, if your hands are already on the keyboard.... HTH, Bernie MS Excel MVP "Boog" wrote in message ... I am running XP with Office 2002. What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
Thank you Martin
"Martin" wrote: You could also use this: CommandBars("Worksheet Menu Bar").Controls("Tools").Controls("Macro").Controls ("Visual Basic Editor").accDoDefaultAction "Boog" wrote: That has to be the only combination I didn't try. Thank you for the prompt solution. Cheers. "Office_Novice" wrote: Sub vbe() Application.vbe.MainWindow.Visible = True End Sub 'Tools --Macro--Security 'Click the Trusted Publisher Tab 'Click Trust access to Visual Basic Project Checkbox 'Click ok "Boog" wrote: I am running XP with Office 2002. What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing the VBA Editor using code | Excel Worksheet Functions | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
RegEx in VBE code editor | Excel Programming | |||
Get VSTO code to run on every launch of Excel | Excel Programming | |||
printing module code from vba editor | Excel Programming |