Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Snippet - Activate VBE window
Hi
Can someone supply a neater way to actrivate the VB window using a macro,please? I used the code below but I think there must be something better: ThisWorkbook.VBProject.VBE.MainWindow.SetFocus Thanks Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Snippet - Activate VBE window
On Nov 9, 12:58*pm, "Tim Childs" wrote:
Hi Can someone supply a neater way to actrivate the VB window using a macro,please? I used the code below but I think there must be something better: ThisWorkbook.VBProject.VBE.MainWindow.SetFocus Thanks Tim Why not just use the icon from the viewtoolbarsvisual basic |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Snippet - Activate VBE window
hi
thanks hor that but the reason i because I wanted it was to incorporate it into a proc that needs to run in the VB window to work properly... Tim "Don Guillett Excel MVP" wrote in message ... On Nov 9, 12:58 pm, "Tim Childs" wrote: Hi Can someone supply a neater way to actrivate the VB window using a macro,please? I used the code below but I think there must be something better: ThisWorkbook.VBProject.VBE.MainWindow.SetFocus Thanks Tim Why not just use the icon from the viewtoolbarsvisual basic |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Snippet - Activate VBE window
On Nov 10, 1:23*am, "Tim Childs" wrote:
hi thanks hor that but the reason i because I wanted it was to incorporate it into a proc that needs to run in the VB window to work properly... Tim "Don Guillett Excel MVP" wrote in ... On Nov 9, 12:58 pm, "Tim Childs" wrote: Hi Can someone supply a neater way to actrivate the VB window using a macro,please? I used the code below but I think there must be something better: ThisWorkbook.VBProject.VBE.MainWindow.SetFocus Thanks Tim Why not just use the icon from the viewtoolbarsvisual basic Sub GotoVBE() Application.VBE.MainWindow.Visible = True End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Snippet - Activate VBE window
Hi Don
thanks for sending that - will deploy in the proc. bw Tim "Don Guillett Excel MVP" wrote in message ... On Nov 10, 1:23 am, "Tim Childs" wrote: hi thanks hor that but the reason i because I wanted it was to incorporate it into a proc that needs to run in the VB window to work properly... Tim "Don Guillett Excel MVP" wrote in ... On Nov 9, 12:58 pm, "Tim Childs" wrote: Hi Can someone supply a neater way to actrivate the VB window using a macro,please? I used the code below but I think there must be something better: ThisWorkbook.VBProject.VBE.MainWindow.SetFocus Thanks Tim Why not just use the icon from the viewtoolbarsvisual basic Sub GotoVBE() Application.VBE.MainWindow.Visible = True End Sub __________ Information from ESET Smart Security, version of virus signature database 5608 (20101110) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to modify this VBA code snippet | Excel Programming | |||
Want to modify this VBA code snippet | Excel Programming | |||
Workbook.Activate / Window.Activate problem | Excel Programming | |||
Problem in WITH/END WITH code snippet | Excel Programming | |||
Code snippet storage | Excel Programming |