Picture loading in image problem

[hunsnowboarder]

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

[royUK]

What do you mean by imgFace?

Try using an Image Control from the Controls ToolBox

[hunsnowboarder]

"imgFace" is the name of the image.

[Tom Schreiner]

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 = ...