Function help

[dave8]

I created a Function in a Module. In my UserForm, I call this function to return a value.
For example:

Function name1(variable1 as string, variable2 as string) as long
Dim Count as long
..Count something
name1 = Count
End function


When this function returns from the calling routine in my UserForm, why can't I get the value? I want to display the count (name1) of the function routine. Am I missing a fundamental rule here?

 

[VoG]

You haven't shown how you are calling it or where the result should be displayed.

 

[Jonmo1]

Make sure you're assigning the result of the function to a variable...

Dim X As Long
X = name1("A","B")

 

[Scott Huish]

YOu shouldn't name your variables the same as VBA keywords. I would use something else for your variable name.

 

[dave8]

Ah yes, thank you. I understand.