Procedure Declaration for Events Error in Spreadsheet Component

D

Dan

I'm trying to use the SheetChanged event of the OWC10 spreadsheet
component. I'm using the parameters that are in the object browser AND
the documentation.

I keep getting:

Compile Error:

Procedure Declaration does not match description of event or procedure
having the same name

I've tried this:

Sub ssEffort_SheetChange(ByVal Sh As Object, ByVal Target As Range)

This:

Sub ssEffort_SheetChange(Sh, Target)

And this:

Sub ssEffort_SheetChange(Sh As Worksheet, Target As Range)

and I'm still getting this annoying error. Please help.
 
D

Dan

In fact, none of my events that have properties are working. I get the
same stupid error.

By the way, I'm doing this on a VBA form.

Dan
 
A

Alvin Bruney [ASP.NET MVP]

The components are unable to hook into events by default. It's really not
their fault, the problem lies elsewhere. The fix is to follow Q328275.
(source p. 203 Owc black book)

--
Regards,
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
_________________________
 
Top