Picture loading in image problem

Hi there Everyone! I have a very basic and simple macro which won't work. (I am just starting to lear VBA).

I have an excel worksheet and an imgFace image on it. All I want is that when I start the macro a picture to be displayed on this image (face.bmp)

When I run the macro I get an error message saying: "Run time error '424': Object required". Please tell me what am I doing wrong.

Please Login or Register  to view this content.

Thank you in advance!

Thanks

"imgFace" is the name of the image.

If your code is located outside of the sheet containing the image control, make sure you qualify the image object by providing information about its parent.

Sheet1.imgFace.Picture = ...
or
WorkSheets("Sheet1").imgFace.Picture = ...
or
Set Sheet1.imgFace.Picture = ...
or
Set WorkSheets("Sheet1").imgFace.Picture = ...