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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch?
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch?
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch?
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) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch?
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) |
Reply |
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 |