Find name of picture

[StevenD]

Hi,

I add a picture to a sheet using the .addPicture code. Depending upon what is in a combobox.

This works fine, but I would like to send this picture to the back automatically as I have some text that needs to be in front of it.

Unfortunately I cannot find a name for the picture.

I have found this code using macro recording

ActiveSheet.Shapes("Picture 1").Select
    Selection.ShapeRange.ZOrder msoSendToBack

Obviously the name of the picture changes each time the combobox changes, so i need some code to find out the name of the picture that i have inserted.
This way I could use the following code

PictureName=(need code here)
ActiveSheet.Shapes(PictureName).Select
    Selection.ShapeRange.ZOrder msoSendToBack

 

[Juan Pablo González]

You should be able to do

.AddPicture(...).ZOrder msoSendToBack

all in one single operation.