PDA

View Full Version : Solved: shapes in a worksheet



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

Bob Phillips
10-27-2009, 05:48 AM
Have a look at http://datapigtechnologies.com/blog/index.php/data-bars-in-excel-2003-without-rept/

philfer
10-27-2009, 05:57 AM
Hey,

Nice one, excellent....thanks a million for that