How to insert a specific shape & add text from a cell into it?

**daksh1981** · 06-30-2010, 07:13 AM

I need your help on How to insert a specific shape in excel & how to add a text from a specific cell in this shape?
I am attaching a sample file in which I have inserted a sample shape which I want to be added through VBA. I have also mentioned the text in Column A2 which I want inside this shape with VBA.

**Andy Pope** · 06-30-2010, 08:01 AM

Use your xl2003 version and the macro recorder to get code

Please Login or Register  to view this content.

**daksh1981** · 06-30-2010, 08:49 AM

Thanks Andy Pope for the quick response. I am using Excel 2007 I do not have Excel 2003 installed.
Though this has resolved my query, Can you please guide how I can get information on setting the properties of this shape in VBA like shape color, shape text color, background color etc. ?
This will be a great help.

**Andy Pope** · 06-30-2010, 09:55 AM

Try using the Object browser and help as well as searching forum for previous examples.

If you don't have xl2003 why is it in your profile?

**royUK** · 06-30-2010, 09:57 AM

You attached a 2003 workbook!

Wouldn't it be simpler to have a shape that is hidden and unhidden as required?

**daksh1981** · 06-30-2010, 10:03 AM

Hi Andy Pope,

The system which I am using right now does not have Excel 2003. This is an official system where we can only use Excel 2007.

royUK: I don't need shape to be hidden or unhidden, I just wanted to add a specific shape with a specific text in my active sheet.