|
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Address(0, 0) = "F3" Then
- Dim Rng As Range, Pic As Shape
- On Error Resume Next
- Set Rng = Range("J4") '照片单元格
- Path = ThisWorkbook.Path & "\照片" '图片路径
- For Each Pic In Shapes
- If Pic.Name Like "*照片" Then Pic.Delete
- Next
- Sheet1.Shapes.AddPicture(Path & Range("F3").Value & ".JPG", 1, 1, Rng.Left + 2, Rng.Top + 2, 170, 250).Name = Range("F3") & "照片"
- End If
- End Sub
复制代码 |
|