'This example adds a picture created
'from the file Music.bmp to myDocument.
'The inserted picture is linked to the file
'from which it was created and is saved with myDocument.
Dim myDocument
Dim c As Range
Set myDocument = Worksheets(1)
myDocument.Shapes.AddPicture _
"C:\Documents and Settings\andy\My Documents\My Pictures\CheckBox.bmp", _
True, True, 100, 100, 70, 70
'insert picture in B2 top-left corner
Set c = Worksheets(1).Range("B2"
myDocument.Shapes.AddPicture _
"C:\Documents and Settings\andy\My Documents\My Pictures\CheckBox.bmp", _
True, True, c.Left, c.Top, 50, 50
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.