Macros para BUSCAR imágenes con EXCEL

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ม.ค. 2025

ความคิดเห็น • 1

  • @grupodeformacionadministra4080
    @grupodeformacionadministra4080  2 ปีที่แล้ว

    Private Sub Worksheet_Change(ByVal Target As Range)
    On Error Resume Next
    Image1.Picture = LoadPicture(ActiveWorkbook.Path & "\FOTOS\" & Sheets("FICHA COMPARATIVA").Range("A2").Value& & (".jpg"))
    If Err = 53 Then
    Image1.Picture = LoadPicture(ActiveWorkbook.Path & "\FOTOS\" & Sheets("FICHA COMPARATIVA").Range("B2").Value& & (".jpg"))
    End If
    On Error Resume Next
    Image2.Picture = LoadPicture(ActiveWorkbook.Path & "\FOTOS\" & Sheets("FICHA COMPARATIVA").Range("C2").Value& & (".jpg"))
    If Err = 53 Then
    Image2.Picture = LoadPicture(ActiveWorkbook.Path & "\FOTOS\" & Sheets("FICHA COMPARATIVA").Range("D2").Value& & (".jpg"))
    End If
    End Sub