jump to function or procedure

[Jim8541]

Hi, is there a way to jump to a function or procedure when I'm working in the VBA editor window?
Thanks

 

[llkhoutx]

When you say

Hi, is there a way to jump to a function or procedure when I'm working in the VBA editor window?
Thanks

I presume that you mean execute the function or procedure.

For Functions use

var = YourFunctionName(), where var is the datatype returned.

For Subroutines use

Call YourSubroutineName

 

[Mile-O]

I read it as finding the sub amongst all the VBA code over different modules.

The quickest way would be to open the Object Browser, find your object, and then double click on the sub you want.

 

[The Stoat]

If you highlight the function or sub you are calling as you would to copy some text i.e. - the bit in bold -


X = Myfunction("Test")


and then press shift and the F2 button you will "jump" to the sub or function that is being called.

Hope that helps

TS

 

[ecniv]

On the vba Editing window.
Top Left dropdown - all the controls (for form modules)
Top right dropdown - all subs/functions

If you are in the code and you have a function/sub which you want to see, right mouse click>definition

Plus all the other posts above.


Vince

 

[Jim8541]

Thanks, excellent help.