VSTO Reference to a non-shared member 1

[sabloomer]

I am new to VB.net am having an issue with a VSTO Excel 2007 Add-on that I am working with. This add-on has an Actions Pane that acts like the summary section of the sheet. When the user updates values on the sheet I want the pane to update.

So far I have a working Actions Pane and I have added the following code to the "Application_SheetChange" section of my project....

If Target.Address = "$B$10" Or Target.Address = "$B$11" Then

Call ScoreCard.ExcelPush()

End If

The problem is that I am told "Reference to a non-shared member requires an object reference". One article I found on-line suggsted that I add the following...

Dim myScoreCard As New ScoreCard
myScoreCard.Show()
myScoreCard.ExcelPush

This does not generate any errors, but the ScoreCard does not appear to update. From reading I think that this is because I have created a second instance and am updating the wrong instance. Is there any way to point myScoreCard to the existing instance instead of a new one? I have read a few articales, but only found myseld more confused. Thank you to anyone that can help explain this.

Thanks,

sabloomer

 

[PHV]

I am new to VB.net
You may get more answers here:
forum796

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sabloomer]

Thank you, I thought I was in the right forum.