If statement, autoshapes and multiple sheets

[subsoa]

Hi forum,

I'm trying to create a workbook that (when done) is able to insert autoshape depending on the variable of a cell.
F.x.:

if cell sheet!1 A1 == 1 then
insert autoshape_1 from Sheet!2 in cell B2
insert into autoshape_1/cell B3 "value from cell A2"
if else sheet!1 A1 == 2
insert autoshape_2 from Sheet!2 in cell B2
insert into autoshape_2/cell B3 "value from cell A2"

this isn't the correct code, know that much, but I'm having trouble inserting autoshapes if an if statement is true.

-------------------------------------------------------------------
Sheet 1 : interface
Sheet 2 : keeps track of data + where autoshapes are placed.

I've tried creating macro's but I'm thinking there should be a more suffiecient way than running a macro for inserting an autoshape depending on a cells value.

Also seen something similar done with pictures, but I need the autoshapes, to be able to fill in text into them, and wasn't able to convert the VBA script found : http://www.mrexcel.com/forum/excel-questions/245508-dont-know-if-can-done.html#post1203350

If it matters, I'm running Office 2003. :/


Any help is greatly appriciated!!

 

[patel45]

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

 

[subsoa]

Thanks!!!!
Lots of good stuff!