Spreadsheet control

[gtmeloney]

I have a spreadsheet control inside of a userform. I can generally access this spreadsheet and do what I need to do with it. My problem is that I need to monitor it for the cell change event. I normally accomplish this with:

Please Login or Register  to view this content.

in the 'code' portion of the particular worksheet that I want to monitor. I have the same thing in the spreadsheet object that I have inserted onto the userform, but the event never gets triggered.

Any ideas?

[gtmeloney]

I think what I really need to do is put a Worksheet in the userform, as opposed to the Spreadsheet that I'm currently using. (I believe a spreadsheet is composed of 1 or many Worksheets). There is no Worksheet control though, is there another way to embed a worksheet inside of a userform?

[Leith Ross]

Hello gtmeloney,

If you are using a OCW spreadsheet control then use the Private Sub Spreadsheet1_SheetChange(ByVal Sh As OWC11.Worksheet, ByVal Target As OWC11.Range) event. This code is for the Excel 2003 OCW control.

[gtmeloney]

Thanks Leith. That does the trick.

Does OWC11 tell VB that we're dealing with an ActiveX object as opposed to a regular old Excel object?

[Leith Ross]

Hello gtmeloney,

Yes, it dioes. There are some properties that similar to an Excel worksheet. So, it is a good practice to qualify those properties and methods with the object class name OCW11, so VBA doesn't reference the wrong object.