|
gmshe58 发表于 2011-11-19 11:58
谢谢。你写的这段宏比较好理解,但是,路径错误了(或者有路径无照片)。怎么改写为好?出错要调试比较烦 ...
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim r As Integer, c As Integer
- Dim p As String, f As String
- r = Target.Row
- c = Target.Column
- p = "c:\123"
- If Dir(p) <> "" Then
- If r > 1 And c = 2 And Cells(r, c + 1) <> "" Then
- f = Cells(r, c + 1) '所选的右边单元格
- Else
- f = "无照片.jpg" '空路径时
- End If
- '这里是向自选图形里填充图片文件(文件路径是p & f)
- Shapes(1).Fill.UserPicture p & f
- Else
- MsgBox "路径错误,或没有图片。", vbExclamation, "提示"
- End If
- End Sub
复制代码 |
|