ways to call "sub" routines

[MetLife]

Hi,

I am analyzing someone else's code. One thing I notice is that they alternate between

run("some_macro")

and

call some_macro

Why is there a difference in the way the macro is called & does this make any difference?

I personally don't like changing the way it is called, I would prefer just using the "Call" command or "run" but alternating is confusing to me.

Thanks

 

[RoryA]

Unless you have a specific reason to use Run (eg you are calling a routine in another workbook) I would always recommend using a direct call to the routine - although actually using the Call keyword is unnecessary.

 

[My Aswer Is This]

I always use:

Call Bob
Or
Call Me

It helps me remember what's happening here in this line of code.

If I just see

Bob

I think what is Bob

 

[MetLife]

I think the exact same thing. For me it is better if we are limited to just using "Call Bob" etc...

I also think it is better if the vba will automatically color code variables/functions automatically. This also helps clear things up. I wonder why this isn't implemented?

 

[RoryA]

You can change the formatting of most things in the VBE using the colour options.

If you were limited to Call, you wouldn't be able to run code in other projects without setting references, nor could you build up routine names at runtime. It is entirely up to you what practices you adopt. Limiting the language further would not, in my opinion, be an improvement.

 

[MetLife]

I see in "tools-> options-> Editor Format" they have the options to change color for comments and errors. I don't see the variables or sub routines though.

 

[RoryA]

"Identifier text" is the one you want.

 

[My Aswer Is This]

RoyA

If there is a easy way to color some lines of code quickly
Would you please explain more about how to do that.

Do we always have to select line of code and then go into Tools and Text identifier. Etc.

 

[RoryA]

No, there isn't. Why would you want to colour entire lines of code?

 

[My Aswer Is This]

I thought that was what you were saying when you said:

You can change the formatting of most things in the VBE using the colour options.​

I thought you were saying we could color something like Call Bob. So it would stand out from the other code.

​

No, there isn't. Why would you want to colour entire lines of code?