Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VSTO Reference to a non-shared member 1

Status
Not open for further replies.

sabloomer

Technical User
Aug 8, 2003
153
US
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
 
I am new to VB.net
You may get more answers here:
forum796

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Thank you, I thought I was in the right forum.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top