A picture as cell bakground or cell pattern

[n-kadkhodaei]

Hi
How can I insert a small picture as a cell 'Background' or 'Pattern'? How can I assign a picture to a cell. I want to insert a picture as a pattern of a single cell. For example I want to show my photograph in an indivigual cell as cell pattern or cell back ground.
Thank you for your attention.
N-KADKHODAEI

 

[tusharm]

You cannot associate a cell with a picture let alone as a background. In XL, pictures reside in a "layer" above the cells.

That said, you can *simulate* the effect of linking a cell with an image but it will hide anything in the cell.

Through the UI just drag and adjust the shape of the image to fit that of the cell.

Through code, adjust the shape's left, top, width, and height to match those of the cell of interest.

In both cases, ensure that you set the shape's properties so that it sizes and moves with the cell.

 

[Bartek]

Hi,

How can I insert a small picture as a cell 'Background' or 'Pattern'? How can I assign a picture to a cell. I want to insert a picture as a pattern of a single cell. For example I want to show my photograph in an indivigual cell as cell pattern or cell back ground.

You can use a picture as a background (texture) in Excel with Format > Sheet > Background. However, this texture will be applied to all cells in a worksheet.

Background is only visible if ColorIndex of a Cell.Interior is set to xlColorIndexNone, otherwise, interior color will override the background.
Thus, by carefully positioning background image and coloring interior of all cells except a selected few, you can create an illusion that some cells have background picture. But this is rather tiresome and unreliable method - any changes like deleting or resizing rows will spoil the effect