Visual Basic para Aplicaciones - Control de Imagen con imagen de Internet

Image1.Picture = LoadPicture("MI RUTA EN INTERNET")

Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

Public Function DownloadImagen(URL As String, ArchivoLocal As String) As Boolean

   Dim Retorno As Long

   '

   Retorno = URLDownloadToFile(0, URL, ArchivoLocal, 0, 0)

   '

   If Retorno = 0 Then DownloadImagen = True

   '

End Function

Private Sub Command1_Click()

   '

   DownloadImagen "http://www.DIRECCION_DE_LA_IMAGEN", ThisWorkbook.Path + "\Imagen.jpg"

   '

   UserForm1.Image1 = LoadPicture(ThisWorkbook.Path + "\imagen.jpg")

   '

End Sub