Hi,
I'm trying to simplify some of my VBA function codes. For example:
Is it possible to not keep typing in the "zzz = x+y" line in each function that needs the "zzz" value?![]()
Please Login or Register to view this content.
Thanks,
Jay
Hi,
I'm trying to simplify some of my VBA function codes. For example:
Is it possible to not keep typing in the "zzz = x+y" line in each function that needs the "zzz" value?![]()
Please Login or Register to view this content.
Thanks,
Jay
Last edited by Jay637; 04-17-2008 at 06:16 PM.
Jay, please edit your post to use code tags. If you don't know how, please read the forum rules.
![]()
Please Login or Register to view this content.
Thanks for the quick reply, shg.
I'm sorry I wasn't clear in my question.
The above line of code is actually supposed to be a really long equation that I reuse in a few on my functions. Is there a way of just determining the value once in a module then being able to use that value for a few different functions without reentering it in each of my function codes?![]()
Please Login or Register to view this content.
Thanks,
Jay
Yes: encapsulate it as a function of its own.
That's why you have a Sin function, so you don't have to code a Taylor series expansion every time you need one![]()
Thanks a lot shg... I appreciate the help!
Last edited by Jay637; 04-17-2008 at 07:49 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks