tinyjack
10-11-2004, 09:09 AM
This is bugging me, how do I get rid of the Select?
Dim shpItem as Shape
Set shpItem = Sheet2.Shapes.AddShape(msoShapeFlowchartDecision, GAP, (lngScreenBottom / 2) - (HEIGHT / 2), WIDTH, HEIGHT)
shpItem.Fill.Solid
shpItem.Fill.ForeColor.SchemeColor = 43
shpItem.Name = "Start"
Sheet2.Shapes("Start").Select
Selection.Characters.Text = "Bugging Me"
Any thoughts?
TJ
Dim shpItem as Shape
Set shpItem = Sheet2.Shapes.AddShape(msoShapeFlowchartDecision, GAP, (lngScreenBottom / 2) - (HEIGHT / 2), WIDTH, HEIGHT)
shpItem.Fill.Solid
shpItem.Fill.ForeColor.SchemeColor = 43
shpItem.Name = "Start"
Sheet2.Shapes("Start").Select
Selection.Characters.Text = "Bugging Me"
Any thoughts?
TJ