Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling on Methods and Properties within Worksheet Modules
From within a class modules, is there a viable way to call on a public
method and/or property that is setup within a worksheet module? I have setup a procedure with the following signatu Public Sub pcdInitializeWorksheet(ByRef l_objScheduleRangeNames As clsScheduleRangeNames) and within the class module that is attempting to call on it, it's setup as: l_wsh.pcdInitializeWorksheet m_objScheduleRangeNames The object variable "l_wsh" is within a For Each...Next loop, which is a worksheet object. At the time it's compiling, it's erroring out stating the above method, "pcdInitializeWorksheet", is not found. If I comment out that one line of code, everything compiles just fine. If it's not feasible to use worksheet modules as such, then I will be left with no choice but to emulate the worksheets. -- Thanks, Ronald R. Dodge, Jr. Production Statistician Master MOUS 2000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling Excel methods from a different thread (COM add-in) | Excel Programming | |||
Available methods and properties through OLE interface | Excel Discussion (Misc queries) | |||
Hidden workbook properties/methods | Excel Programming | |||
HELP! Object, Properties & Methods | Excel Programming | |||
Ctrl-J list of properties and methods | Excel Programming |