I am working on a project involving images, but I am a little hung up at the very start. My project involves lists of of data, and there are ~12 different types of items, and each item corresponds to a different symbol, so I was planning on having a template sheet which would grab the appropriate item's symbol and place it in the respective cell on the main sheet. However I can't seem to figure out how to place the .bmp images into a cell to easily access it via a macro.
Using the macro recorder it gives me something like this:
But I need it to be so that I can select and manipulate the images by selecting cells. I think that gives a decent description of what I'm up against, any ideas?
Using the macro recorder it gives me something like this:
Code:
ActiveSheet.Shapes("Object 4").Select
Selection.ShapeRange.IncrementLeft 32.25
Selection.ShapeRange.IncrementTop 3#
ActiveSheet.Shapes("Picture 3").Select
Selection.ShapeRange.IncrementLeft 25.5
Selection.ShapeRange.IncrementTop -2.25
ActiveSheet.Shapes("Object 4").Select
Selection.ShapeRange.IncrementLeft -106.5
Selection.ShapeRange.IncrementTop 31.5
But I need it to be so that I can select and manipulate the images by selecting cells. I think that gives a decent description of what I'm up against, any ideas?