application.goto to go to a form

**noclass1980** · 11-19-2012, 10:09 AM

Hi, wonder if anyone can help with this question. I know that I can use Application.Goto (ProcedureName) to go to a specific VB procedure in the Editor in the same workbook but is it possible to go to a procedure which is in a different workbook? I actually want to go to a specific form in another workbook and show it in the VBE so the user can look at any code that is contained within the form such as UserForm1_Initialize. To illustrate, Book 1 contains the procedure that opens the VBE but Book 2 has the form that I want to the user to view in the VBE.
Thanks in advance.

**JosephP** · 11-19-2012, 10:51 AM

you can't do that with goto as far as I know0you have to manipulate the vbe

Please Login or Register  to view this content.

**noclass1980** · 11-19-2012, 11:04 AM

Thank you! Perfect, does exactly what I needed. Always amazed by the clever knowledgeable folk that are out there and willing to help!

**JosephP** · 11-19-2012, 11:50 AM

my pleasure

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save