i am currently writing a vba code that uses mathematical formulas to iterate and display results graphically. I am currently have an issue of reusing ending variables in next subroutine from previous subroutine. The code is mostly done except for a few debugging issues. Basically, how do I get variable from previous subroutine visible for next subroutine. Any help or direction would be greatly appreciated.
Last edited by damayn83; 01-18-2013 at 05:49 PM.
Declare varibles at module level, so the varaibles would be available throught the module.
I would pass them from one to the next, just as you pass arguments to Excel's native functions in formulas. Small routines that perform relatively atomic functions are easier to maintain and more reusable.
Entia non sunt multiplicanda sine necessitate
Pass values from one procedure or function via its argument list.
Please Login or Register to view this content.
Ben Van Johnson
to declare variables at module level, is that just dimensioning them before any line of code?
Thank you AB33. That solved it. Now on to rest of code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks