Call another Sub Routine

[csprop]

Right now I have a lot of redundant code in three or four different subs. I've tried to create another sub with that code in it, and the new sub in the others to avoid having to write the same code in multiple subs.

How can I tell VB to run the sub contaning the common code from the other subs?

Thanks.

 

[brewpedals]

csprop,

Try creating a Public Function or Sub in it's own module and call it from a Private Sub using:

CALL My_Function
or
My_Function
or
=My_Function()

Do a help search for Public vs. Private

Good luck.

 

[csprop]

You were correct. I was using a Private sub instead of a Public sub. Nine out of ten problems I come across are caused by mundane details which I should have known better.

Thanks for the wake up call!

 

[brewpedals]

Me too, but don't tell anyone. It'll be our secret