How to Insert picture to user form a url in Excel cell.?

Question

Hi Everyone

I am looking for the answer for How to Insert picture to a user image area form a url in Excel cell.?

Both the excel sheet and user form screenshots are given below.

Please help me.

Thanks

Shozib

Answer 1

Image controls support only one format: StdPicture (which is a data structure in memory).

LoadPicture convert the picture into that data structure. LoadPicture support bmp gif ico wmf, most jpg and a few older file formats.

If you want to load png or tif you have to use GdiPlus... A lot of code, e.g.

http://www.vbarchiv.net/tipps/tipp\_1264-ersatz-fuer-die-vb6-loadpicture-funktion.html

Andreas.

Answer 2

I have downloaded the pics. . Now the pics are in cells in Excel.

Why? The code of the mentioned website shows how to download a picture and load it into the image control.

Furthermore, pictures can not be loaded into cells in Excel... if you import a picture into Excel the picture becomes a shape. Useless.

Anyway if you have the file on your disk, use LoadPicture to load the file into the image control.

Andreas.

Private Sub UserForm_Initialize()

  Me.Image1.Picture = LoadPicture("C:\whatever\test.bmp")

End Sub

Answer 3

You have to download the picture first, then you can load it as usual:

http://www.vb-helper.com/howto_download_url_to_file.html

Andreas.

Answer 4

Thanks for your reply. I have downloaded the pics. . Now the pics are in cells in Excel. Could you please tell me how can I now load a specific pic into user form??

Answer 5

Thankyou so much