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
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