Image Loading

[Greg B]

How do you get a imagebox on a userform to load a picture from a file?

I can not work this one out. I can not seem to work out the code needed to
activate the code.

Thanks

Greg

 

[Nigel]

Me.Image1.Picture = LoadPicture(file path & filename)

 

[Greg B]

Thanks Nigel
work great
Greg

Me.Image1.Picture = LoadPicture(file path & filename)


--

Regards,
Nigel
(e-mail address removed)

 

[sbweid]

Nigel, this does not work for me. I get a compile error: wrong number of
arguments or invalid property assignment. Here is my code:

Sub LoadPicture()
Dim Fname As String
Fname = ThisWorkbook.Path & "\Linda & Steve.jpg"
LeaderCare.Image1.Picture = LoadPicture(Fname)
End Sub

 

[Nigel]

Are you trying to load picture into a UserForm object or directly into a
worksheet?

--

Regards,
Nigel
(e-mail address removed)