ControlCollection.AddPictureBox Method (Double, Double, Double, Double, String)

Adds a new PictureBox control to the worksheet in the specified size and location.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)


Public Function AddPictureBox ( _
    left As Double, _
    top As Double, _
    width As Double, _
    height As Double, _
    name As String _
) As PictureBox
Dim instance As ControlCollection
Dim left As Double
Dim top As Double
Dim width As Double
Dim height As Double
Dim name As String
Dim returnValue As PictureBox

returnValue = instance.AddPictureBox(left, _
    top, width, height, name)
public PictureBox AddPictureBox(
    double left,
    double top,
    double width,
    double height,
    string name


  • left
    Type: System.Double
    The distance in points between the left edge of the control and the left edge of the worksheet.
  • top
    Type: System.Double
    The distance in points between the top edge of the control and the top edge of the worksheet.
  • height
    Type: System.Double
    The height of the control in points.

Return Value

Type: Microsoft.Office.Tools.Excel.Controls.PictureBox
The PictureBox control that was added to the ControlCollection instance.


Exception Condition

The name argument is nulla null reference (Nothing in Visual Basic) or has zero length.


A control with the same name is already in the ControlCollection instance.


The AddPictureBox method enables you to add PictureBox objects to the end of the ControlCollection. To remove a PictureBox control that was previously added programmatically, use the Remove() method.


The following code example adds a PictureBox control to the top of the worksheet, and then adds an image. The example assumes a file named Image.jpg exists at the root of the C directory.

    Private Sub ExcelAddPictureBox()

        Dim PictureBox1 As Microsoft.Office.Tools. _
            Excel.Controls.PictureBox = Me.Controls. _
            AddPictureBox(0, 0, 150, 150, "PictureBox1")

        PictureBox1.Image = System.Drawing.Image. _

    End Sub

private void ExcelAddPictureBox()

         pictureBox1 = this.Controls.AddPictureBox(
         0, 0, 150, 150, "pictureBox1");
    pictureBox1.Image = System.Drawing.Image.FromFile(

.NET Framework Security

See Also


ControlCollection Class

ControlCollection Members

AddPictureBox Overload

Microsoft.Office.Tools.Excel Namespace