Code Snippet - Activate VBE window

  • Thread starter Thread starter Tim Childs
  • Start date Start date
T

Tim Childs

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
 
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
Click to expand...

Why not just use the icon from the view>toolbars>visual basic
 
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

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
Click to expand...

Why not just use the icon from the view>toolbars>visual basic
 
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





Why not just use the icon from the view>toolbars>visual basic
Click to expand...

Sub GotoVBE()
Application.VBE.MainWindow.Visible = True
End Sub
 
Hi Don

thanks for sending that - will deploy in the proc.

bw

Tim

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

message



Why not just use the icon from the view>toolbars>visual basic
Click to expand...

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
 
Back
Top