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

On Nov 9, 12:58*pm, "Tim Childs" <zx...@NOSPAMyahoo.co.uk> 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 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

"Don Guillett Excel MVP" <(E-Mail Removed)> wrote in message
news:9dfa566f-98c2-416c-b9f6-(E-Mail Removed)...
On Nov 9, 12:58 pm, "Tim Childs" <zx...@NOSPAMyahoo.co.uk> 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 view>toolbars>visual basic

On Nov 10, 1:23*am, "Tim Childs" <zx...@NOSPAMyahoo.co.uk> 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" <dguille...@austin.rr.com> wrote in messagenews:9dfa566f-98c2-416c-b9f6-(E-Mail Removed)...
> On Nov 9, 12:58 pm, "Tim Childs" <zx...@NOSPAMyahoo.co.uk> 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 view>toolbars>visual basic

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

Hi Don

thanks for sending that - will deploy in the proc.

bw

Tim

"Don Guillett Excel MVP" <(E-Mail Removed)> wrote in message
news:1fc741e2-9947-41a3-af91-(E-Mail Removed)...
On Nov 10, 1:23 am, "Tim Childs" <zx...@NOSPAMyahoo.co.uk> 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" <dguille...@austin.rr.com> wrote in
> messagenews:9dfa566f-98c2-416c-b9f6-(E-Mail Removed)...
> On Nov 9, 12:58 pm, "Tim Childs" <zx...@NOSPAMyahoo.co.uk> 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 view>toolbars>visual 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