|
>'===========================================================
>Private Sub CommandButton1_Click()
> Dim pic As Picture
> Dim txt As TextBox
> Call SavePicture(Image1.Picture, ThisWorkbook.Path & "\temp.gif")
> Set pic = ActiveSheet.Pictures.Insert(ThisWorkbook.Path & "\temp.gif")
> Set txt = ActiveSheet.TextBoxes.Add(pic.Left + 6, pic.Top + pic.Height, Label1.Width, Label1.Height)
> With Label1
> txt.Text = Label1.Caption
> txt.Font.Name = .Font.Name
> txt.Font.Size = .Font.Size
> txt.ShapeRange.Fill.ForeColor.RGB = .BackColor
> ActiveSheet.Shapes.Range(Array(pic.Name, txt.Name)).Group
> End With
On Error Resume Next
Kill ThisWorkbook.Path & "\temp.gif"
On Error GoTo 0
> Set pic = Nothing
> Set txt = Nothing
>End Sub
訂正して下さい。要らないファイルは消しておかないと・・・。
|
|