Private Sub Worksheet_Change(ByVal Target As Range) Private Sub Worksheet_Change( ByVal Target As Range) If Target.Address(0, 0) = "E3" 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 If Dir(Path & Range( "E3" ) & ".JPG" ) <> "" Then '用dir函数测试该人的照片文件是不是存在。 ActiveSheet.Shapes.AddPicture(Range( "E3" ) & ".JPG" , 1, 1, Rng.Left + 10, Rng.Top + 5, 90, 120).Name = Range( "E3" ) & "照片" Else '假如笑脸的图片存放的文件名为xiaolian.jpg ActiveSheet.Shapes.AddPicture(Path & "xiaolian.jpg" , 1, 1, Rng.Left + 10, Rng.Top + 5, 90, 120).Name = Range( "E3" ) & "照片" End If End If End Sub |
|
来自: 昵称63861774 > 《excel》