Passing subroutine as a parameter

**jartzh** · 03-26-2009, 11:35 AM

I want to pass the name of the routine as a parameter.

Please Login or Register  to view this content.

so

the code

Please Login or Register  to view this content.

should run macro 2 with the parameter of 7.

I get errors every time I try it (with "calls", "runs",...)

**Andy Pope** · 03-26-2009, 11:47 AM

works for me

Please Login or Register  to view this content.

**tinyjack** · 03-26-2009, 12:02 PM

Andy, did you mean:

Please Login or Register  to view this content.

or you could use

Please Login or Register  to view this content.

TJ

**Andy Pope** · 03-26-2009, 12:05 PM

Indeed I did

Thanks for the correction

**jartzh** · 03-26-2009, 12:31 PM

I am still getting errors:

My code is

Please Login or Register  to view this content.

but I get a "runtime error 13 type mismatch on the "run a(b).
and a "compile error. expected sub,function,or property" fif I try call a(b)

Thanks guys

**Andy Pope** · 03-26-2009, 12:38 PM

loadoverroutine had no argument which meant even after correcting the Run command it would still fail.

Either add the argument to the loadoverroutine routine header or
remove b from the Run command.

Please Login or Register  to view this content.

**jartzh** · 03-26-2009, 03:39 PM

That did it. A.P. is the man.

Thanks.

I love asking questions on this forum because I know there is going to be a remarkable solution.

Passing subroutine as a parameter

LinkBack

Thread Tools

Rate This Thread

Display

Passing subroutine as a parameter

Re: Passing subroutine as a parameter

Re: Passing subroutine as a parameter

Re: Passing subroutine as a parameter

Re: Passing subroutine as a parameter

Re: Passing subroutine as a parameter

Re: Passing subroutine as a parameter

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions