Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch
Can anyone help? I am getting "Type mismatch (error 13)" when I try to call a
method. The method is on a class module. The call is from a userform sub. The call: Dim DataSource as Leaf ... Set DataSource = new Leaf .... various properties of DataSource are used successfully ... .... then the problem call ... DataSource.Insert 1,"^" <<. msg occurs trying to execute this line .... The method: In class module "Leaf" ... Public Sub Insert (ipOrdinal, ipSubValue) Dim Ordinal Dim SubValue .... various statements .... call to another method Exit Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch
Problem solved.
-- Nigel Barton "Nigel Barton" wrote: Can anyone help? I am getting "Type mismatch (error 13)" when I try to call a method. The method is on a class module. The call is from a userform sub. The call: Dim DataSource as Leaf ... Set DataSource = new Leaf ... various properties of DataSource are used successfully ... ... then the problem call ... DataSource.Insert 1,"^" <<. msg occurs trying to execute this line ... The method: In class module "Leaf" ... Public Sub Insert (ipOrdinal, ipSubValue) Dim Ordinal Dim SubValue ... various statements ... call to another method Exit Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type mismatch: array or user-defined type expected | Excel Programming | |||
type mismatch | Excel Programming | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming |