Add Userform Image from Cell Picture Address
 

I am in the process of filling numerous Textboxes when a value is selected from a Listbox.
This part is OK and working.

But now i have 2 x Images on the userform (Imag1 and Image2)

How can i have the picture address(location on my PC) to imput the picture into the Image?
The value in cell T1 will be something like:" \\Server\My Pictures\ABC\123\123A.jpg"

Corey....

Add Userform Image from Cell Picture Address
 

Corey,

UserForm1.Image1.Picture = LoadPicture(Worksheets("Sheet1").Range("T1").Value )

HTH,
Bernie
MS Excel MVP


"Corey" wrote in message ...
I am in the process of filling numerous Textboxes when a value is selected from a Listbox.
This part is OK and working.

But now i have 2 x Images on the userform (Imag1 and Image2)

How can i have the picture address(location on my PC) to imput the picture into the Image?
The value in cell T1 will be something like:" \\Server\My Pictures\ABC\123\123A.jpg"

Corey....