|
添加下面红色字段的语句
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo 100
If Target.Address = "$F$3" Then
Dim Pic As Object, PicPathAndName As String, PicFolder As String
Dim PicT As Integer, PicL As Integer, PicH As Integer, PicW As Integer
'图片文件夹名称
PicFolder = "员工相片"
'所选图片路径
PicPathAndName = ThisWorkbook.Path & "\" & PicFolder & "\" & Range("F3") & ".jpg"
Set Pic = ActiveSheet.Shapes("pic")
'原图片的位置和大小
With Pic
PicT = .Top
PicL = .Left
PicH = .Height
PicW = .Width
End With
'删除原图片
Pic.Delete
'插入所选图片
Set Pic = ActiveSheet.Shapes.AddPicture(Filename:=PicPathAndName, LinkToFile:=msoFalse, _
SaveWithDocument:=msoTrue, Left:=PicL, Top:=PicT, Width:=PicW, Height:=PicH)
'设置图片名称
Pic.Name = "pic"
End If
If Dir("员工相片") = "" Then
MsgBox "没有找到图片"
End If
Set Pic = Nothing
Exit Sub
100
MsgBox "没有图片"
End Sub
|
|