AW: mit optionButton Grafiken erstellen !
05.05.2005 21:51:01
Thomas
also hier mal den code:
Private Sub OptionButton1_Click()
ActiveSheet.Shapes.AddShape(msoShapeIsoscelesTriangle, 360.75, 102.75, 171#, _
129#).Select
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.Solid
Selection.ShapeRange.Fill.ForeColor.SchemeColor = 16
Selection.ShapeRange.Fill.Transparency = 0#
Selection.ShapeRange.Line.Weight = 0.75
Selection.ShapeRange.Line.DashStyle = msoLineSolid
Selection.ShapeRange.Line.Style = msoLineSingle
Selection.ShapeRange.Line.Transparency = 0#
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.ForeColor.SchemeColor = 64
Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
Range("B9").Select
ActiveSheet.Shapes("Rectangle 5").Select
Selection.Delete
Range("B9").Select
End Sub
Private Sub OptionButton2_Click()
ActiveSheet.Shapes.AddShape(msoShapeRectangle, 314.25, 117.75, 184.5, 154.5). _
Select
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.Solid
Selection.ShapeRange.Fill.ForeColor.SchemeColor = 11
Selection.ShapeRange.Fill.Transparency = 0#
Selection.ShapeRange.Line.Weight = 0.75
Selection.ShapeRange.Line.DashStyle = msoLineSolid
Selection.ShapeRange.Line.Style = msoLineSingle
Selection.ShapeRange.Line.Transparency = 0#
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.ForeColor.SchemeColor = 64
Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
Range("B8").Select
ActiveSheet.Shapes("AutoShape 4").Select
Selection.Delete
Range("B8").Select
End Sub
wobei zu sagen ist:
ActiveSheet.Shapes("AutoShape 4").Select
Selection.Delete
funktioniert leider nicht. ...?
gruß, thomas