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 insertpicturefrom 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.

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

On Thu, 7 Jun 2007 11:40:00 -0700, econ wrote:

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 insertpicturefrom 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.

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

econ wrote:

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 insertpicturefrom 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.

--

Dave Peterson

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" wrote:

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

On Thu, 7 Jun 2007 11:40:00 -0700, econ wrote:

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 insertpicturefrom 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.

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 DataSort.


Gord

On Thu, 7 Jun 2007 12:36:02 -0700, econ wrote:

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" wrote:

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

On Thu, 7 Jun 2007 11:40:00 -0700, econ wrote:

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 insertpicturefrom 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.