Calling multiple values from a function within a code

**krish T** · 11-11-2010, 10:44 AM

Hi,

I am writing a macro (main macro). In which I am calling a function having multiple calculations with multiple variables. It is doing all perfect in the function but not returning all these variables in the main macro after this function ends. How can I connect my main macro with these sub functions to get all the output from these functions in the main macro. I don't have any idea.

Can any body help ,me on this?

**BigBas** · 11-11-2010, 10:55 AM

That's very vague. Can you post your code, and detail your intended results?

**krish T** · 11-11-2010, 11:16 AM

Hi

Attached the example sheet. I have given simple example for my understanding purpose. Please look at the code and suggest me how to pass the variables from main code to the sub functions and call variables from sub function to the main code.

Thanks for your help.

**romperstomper** · 11-11-2010, 11:31 AM

Main code:

Please Login or Register  to view this content.

Called code:

Please Login or Register  to view this content.

Note: I changed the name of your array variable as Dir is a VBA function.

**krish T** · 11-11-2010, 11:48 AM

Working perfect. Thanks. But small doubt. When I deleted "As String" from the below line in the called code

Please Login or Register  to view this content.

, it is giving problem in the main code. If that is the case, Do I have define count As Long, stat As String, Time As String in the called code or do I have to define type for all the variables in the called code. Thanks for your help.

**romperstomper** · 11-11-2010, 12:39 PM

Your variable types should match. Since you haven't declared any of the other variables, they are Variants, and therefore they match the sub's declaration. The array argument is declared as an array, therefore if you remove the As String, you are declaring it as an array of Variants (not as a Variant - the two are different), but trying to pass an array of Strings.
It is best to specifically type all the arguments where possible.