|
Sub tt()
Dim rg As Range, rgs As Range, shap As Shape
Dim pat$
On Error Resume Next
Set rgs = Application.InputBox("拉选序号所在的区域,并且本文件所在的文件夹中存在同序号的图片!", "如有疑问QQ399457850", "$A$5:$A$17", , , , , 8)
pat = ThisWorkbook.Path & "\"
For Each shap In ActiveSheet.Shapes
shap.Delete
Next shap
For Each rg In rgs
If rg <> "" Then
Err.Clear
rg.Offset(0, 8).Select
With ActiveSheet.Pictures.Insert(pat & rg.Value & ".jpg")
If Err.Number = 0 Then
.ShapeRange.LockAspectRatio = msoFalse
.ShapeRange.Width = rg.Offset(0, 8).Width
.ShapeRange.Height = rg.Offset(0, 8).Resize(3, 1).Height
' .OnAction = "FDSX"
End If
End With
End If
Next rg
End Sub
|
|