Excel: Grouping and Creating a Texbox + A Shape VBA

Helloguys Icould use a little help . I want to insert a box .....Then " Adda textbox "at the same time . Preferably i would like to groupit as well. So that when i move the rectangle the text box isattached to it . Could someone please help guide me . I am very newto vba and just staring out . I really want to group it upon itscreation u Know ....Thank you guys happy computing EricMaxfield ....

SubDrawRect() '
Set myDocument = ActiveSheet
WithmyDocument.Shapes.AddShape(msoShapeRectangle, _
480, 170, 200,200)
.Name = "A"
.Fill.Visible =msoFalse
.Line.ForeColor.RGB = RGB(48, 48, 48)
.Line.DashStyle= msoLineSolid
.Line.Weight = 2.5
End With

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of December 13, 2013.

For more resources for Microsoft Excel