philfer
10-27-2009, 04:59 AM
Is there any way in VBA to insert a shape thats exactly the same height and width of a cell i.e. it covers a cell exactly.
Then, is there a way to change the size of the shape as the cell changes size
I am trying to try to think of a way to replicate Excel 2007's databars in Excel 2003 and figure a shape that fits a cell exactly and changes size regardless of the size of the cell and which I could subsequently colour would be a good place to start
Any ideas???
Thanks
Phil
Then, is there a way to change the size of the shape as the cell changes size
I am trying to try to think of a way to replicate Excel 2007's databars in Excel 2003 and figure a shape that fits a cell exactly and changes size regardless of the size of the cell and which I could subsequently colour would be a good place to start
Any ideas???
Thanks
Phil