inserting clip art into cells

[Guest]

I am trying to insert clip art so that it is data like numbers in a cell. I
want it to be sortable. When I insert>picture>from clip art it places the
picture on top of the cell, but not in the cell.

I want to be able to sort my file or use the filter function, and have the
pictures (in column E) stay lined up with the definition (in column A).

Is this possible, can anyone help me?

I apologise it this appears twice, I posted it and almost two hours later it
still didn't show up.

 

[Gord Dibben]

You cannot insert an object into a cell.

Clipart sits on top of the cell as a layer.

You can achieve what you want if you format the clipart to "move and size with
cells"


Gord Dibben MS Excel MVP

 

[Dave Peterson]

You do have a couple of replies at your first post.

 

[Guest]

Thanks Gord, although it wasn't really what I wanted to hear.

What I want to do is be able to sort the file, having the picture stay
associated with the row the definition it represents is in. If I place the
picture "in" E5, then sort the rows in descending order (according to column
A), the picture stays in E5. The word it illustrates is no longer beside it.

Is there anyway it can be done using VBA using the image button? Or maybe
I'll have to do something with hyperlinking.

 

[Gord Dibben]

I placed a clipart over E5 and entered "mypic" in F5

Placed three more cliparts over E6, E10, E12 with associated text in F column
so's I would get a good split when sorting.

Set all cliparts to "move and size with cells". Did you forget this part?

Sorted by column F and pictures stayed with the associated text.

NOTE: you must select all columns prior to Data>Sort.


Gord