Objects Moving With Cells

[James A Beggs]

Ok, I've been trying to do things like inserting a button, checkbox, or
picture box into cells and want to be able to have the pictures move with the
cells, and I'm having some trouble doing it.

Let me give you two examples:

1. I have a spreadsheet where you can order each of the columns as you need
to, by alphabet or what have you. I want some of the columns on the same row
as a name to have checkboxes that you can click to indicate of said person
has met the requirements for that row, then when you sort by name
alphabetically, (the first column), the rows should reorder alphabetically.
The checkbox, however, isn't moving.

Likewise, I'd also like to filter based on checkboxes checked or unchecked
in a particular column....

2. I was trying to insert a picture box in an Excel cell (and also in word,
incidentally), where I wanted to be able to change the picture and make sure
the picture reformatted to the size of the picture box / cell. So far,
though, the picture box has always resized to the picture size instead.


Thanks in advance!!!

James A Beggs

 

[Gord Dibben]

You cannot insert objects into cells. Objects have their own layer on top
of the cells.

If you carefully size the objects so their boundaries fit inside the
boundaries of the cells they will sort with those cells.

Assumes you have object property set to "move and size with cells"


Gord Dibben MS Excel MVP

On Fri, 18 Dec 2009 08:43:01 -0800, James A Beggs <James A