Using ActiveX is it possible to edit the text of shapes in Excel?

[ebohannon]

Hello!

So I have an excel file that I am filling in using ActiveX in Labview. I ran into an issue however where I have some "shapes" in the excel file that are being used as check boxes. I need to be able to change the text in them so that they may contain an "X" in certain situations. Is it possible to edit the text of a shape in excel using ActiveX, or do I just need to re-format the excel file so those shapes are actual cells?

Here is a picture for reference as to what I am talking about:

[aputman · Accepted solution]

You'll need to click on each shape and name it.

Then follow this code to edit the text box:

[ebohannon]

That worked perfectly! Thank you so much!