Creating Shapes (Rectangles and Shapes) from input cells

[maverick270]

Hi All,

Im pretty new with VBA and excel, Just wondering if someone could give me a hand with writing some code.

Im trying to create shapes Rectangles and Squares with different colours within an excel sheet, where the length and height of the shapes is generated by input values.

Also is it possible to create 3D shapes, again where the size of the shap is generated by input cell values.


Thanks

Mav

 

[scott_n_phnx]

Check out this page. They have a lot of great code for the autoshapes and you should be able to modify the code that they have to get what you need.

Programming Excel 2007 and Excel 2010 AutoShapes with VBA (Guest Post) - Peltier Tech Blog