Call to goto specified module and open to specified function/sub

[raskew]

Hi -

Looking for the capability to go to (from a highlighted treeview control) specified module and display specified function/sub.

All suggestions appreciated.

Best wishes - Bob

 

[vbaInet]

Hey raskew,

You can use:

Application.VBE.ActiveVBProject.VBComponents("Form_[COLOR=Red]FormName[/COLOR]"). _
                CodeModule.CodePane.SetSelection 8, 1, 12, 100

8 = start of code line
1 = start of column
12 = end of line
100 = end of column

Obviously these values were just for demonstration.

 

[raskew]

Hi -

Thanks much for that!

I also answered my own question when I found where I'd used the
OpenModule method of the Microsoft Access DoCmd object

For example, this line of code:

docmd.OpenModule "Utility Functions", "DeleteTableTest3"

would display the DeleteTableTest3 sub in the Utility Functions module.

Thanks again -- Bob

 

[vbaInet]

Well, there you go. That method skipped my mind.