Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target = Range("a2") Then
Dim MyRoute
MyRoute = InputBox("请录入路径", "路径", ThisWorkbook.Path)
Range("b2").Select
ActiveSheet.Pictures.Insert(MyRoute & "\" & Target & ".jpg").Select
End If
End Sub