<div>
For a better understanding of your problem, paste here more of your code, or upload your spreadsheet if its possible.<br />
The syntax shown seems to invalid...
</div>


For a better understanding of your problem, paste here more of your code, or upload your spreadsheet if its possible.
The syntax shown seems to invalid...

<div>
Does it work if you use an explicit value for the Z-order?<br />
&nbsp;oExcel.Application.ActiveW<wbr />indow.Sele<wbr />ction.Shap<wbr />eRange.ZOr<wbr />der = 0 &nbsp; &nbsp; &nbsp; &nbsp;'msoBringToFront = 0
</div>


Does it work if you use an explicit value for the Z-order?
 oExcel.Application.ActiveWindow.Selection.ShapeRange.ZOrder = 0        'msoBringToFront = 0

<div>
byundt, I tried using explicit value. same issue. &nbsp;<br />
lfcbc75, the code is not on the spreadsheet side. Not sure what other code would be useful. There is too much to add but here is some of it.<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim oExcel As Excel.Application<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim oSheet As Excel.Worksheet<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim oWrkBook As Excel.Workbook<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim oChart As Excel.Chart
</div>


byundt, I tried using explicit value. same issue.  
lfcbc75, the code is not on the spreadsheet side. Not sure what other code would be useful. There is too much to add but here is some of it.

        Dim oExcel As Excel.Application
        Dim oSheet As Excel.Worksheet
        Dim oWrkBook As Excel.Workbook
        Dim oChart As Excel.Chart

<div>
byundt, That did the trick. Thanks alot. I thought I was going to have to do this a different way. 
</div>


byundt, That did the trick. Thanks alot. I thought I was going to have to do this a different way.

<div>
<div class="content wysiwyg-content">
Whats wrong with the second line of code from the following:<br />
<br />
oChart.Shapes.Item(&quot;Text Box 4&quot;).Select()<br />
&nbsp;oExcel.Application.ActiveW<wbr />indow.Sele<wbr />ction.Shap<wbr />eRange.ZOr<wbr />der = Microsoft.Office.Core.MsoZ<wbr />OrderCmd.m<wbr />soBringToF<wbr />ront<br />
I get a &quot;member not found&quot; error which I believe is for the Zorder. &nbsp;I want to move a text box on my chart to the front. Thanks in advance
</div>
</div>


Whats wrong with the second line of code from the following:

oChart.Shapes.Item("Text Box 4").Select()
 oExcel.Application.ActiveWindow.Selection.ShapeRange.ZOrder = Microsoft.Office.Core.MsoZOrderCmd.msoBringToFront
I get a "member not found" error which I believe is for the Zorder.  I want to move a text box on my chart to the front. Thanks in advance

Zorder issue when calling excel shape.

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.