View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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....