Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch?
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
type mismatch--how to fix | Excel Discussion (Misc queries) | |||
Type Mismatch | Excel Programming | |||
Type mismatch | Excel Programming | |||
Type mismatch? | Excel Programming | |||
Type mismatch | Excel Programming |