Read the help on Function under the description of Optional, then below that
look at the as type narrative.


--
Regards,
Tom Ogilvy


"Gixxer_J_97" wrote in message
...
thanks guys - the 'object' worked

i guess my question now is why it wouldn't work with Label?



"Jim Thomlinson" wrote:

If that doesn't work... (Probably will. Tom is usually right...) try

public sub myFunc(a as variant, b as variant, optional c as variant,
optional
d as variant)

And then place a watch on a, b, c, and d just to see what you really
have
passed. It can be easy to pass the wrong thing.

HTH


"Tom Ogilvy" wrote:

try

public sub myFunc(a as string, b as string, _
optional c as integer, optional d as Object)


--
Regards,
Tom Ogilvy




"Gixxer_J_97" wrote in message
...
hi all!

i have a sub defined in a module:
public sub myFunc(a as string, b as string, optional c as integer,
optional
d as label)
....
end sub

calling this from a userform:

call myFunc(a,b,c,d)

where
a and b are TextBox (defined in the UserForm)
c is an integer defined private c as integer
d is a Label (defined in the userform)

all variables have a value

i am getting a type mismatch error on this call
call myFunc(a,b,c,d)
.... why?
(i have also tried a.value, a.text, cstr(a) and that hasn't worked.
i've
also tried cint(c)