PDA

View Full Version : Resizing the Autoshape



N3K
08-09-2006, 08:59 PM
http://i11.photobucket.com/albums/a187/NicholasFoo/3digits.jpghttp://i11.photobucket.com/albums/a187/NicholasFoo/4digits.jpg
I need to know how to resize the bracket according to the dynamic size of the cell. The bracket doesn't resize with the cell. When the cell becomes bigger, the bracket still remains the same. I am using Excel VBA 2003. Anyone please help me? :help

TrippyTom
08-10-2006, 08:06 AM
hmm.. it works for me

1) right click the shape
2) choose Format Autoshape
2) on the Properties tab, make sure the option to "Move and Size with cells" is enabled.

If you have any merged cells, that might be affecting things.

Killian
08-10-2006, 08:53 AM
The Autoshape isn't resizing with the the text..?
Format Autoshape>Alignment Check "Automatic size"

lucas
08-10-2006, 09:17 AM
Maybe he's trying to put the text in the cell....not in the autoshape.

TrippyTom
08-10-2006, 11:15 AM
In my test, I had the numbers in 4 different cells.
I held down alt and moved each autoshape to align it with a cell and made sure i had them move and size with cells.

That should work.