|
qqyyh 发表于 2012-8-2 22:07
我怎么测试不成功?还是上传附件给你看看.谢谢!
既然 单元格里的数字就是对应的 图片名称,那就直接调用就是了嘛
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim P As String, Shap As Shape
- For Each Shap In Sheet1.Shapes
- If InStr(1, Shap.Name, "Picture") Then Shap.Delete
- Next
- 'Image1.Visible = False
- With Target
- If .Count > 1 Then Exit Sub '如果选择的单元格个数大于1 ,则退出
- If .Column <> 2 Then Exit Sub '如果选择的不是第三列,则退出
- If .Row < 2 Then Exit Sub '如果选择的单元格小于第三行,则退出
- If .Value = "" Then Exit Sub
-
- P = ThisWorkbook.Path & "\pic" & .Value & ".jpg"
- If Len(Dir(P)) = 0 Then Exit Sub
- With Pictures.Insert(P)
- .ShapeRange.IncrementLeft Target.Left + 10
- End With
- End With
- End Sub
-
复制代码 |
|