Hello guys
I could use a little help . I want to insert a box .....Then " Add a textbox "at the same time . Preferably i would like to group it as well. So that when i move the rectangle the text box is attached to it . Could someone please help guide me . I am very new to vba and just staring out . I really want to group it upon its creation u Know ....Thank you guys happy computing
Eric Maxfield ....
Sub DrawRect() '
Set myDocument = ActiveSheet
With myDocument.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
End Sub
Bookmarks