LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

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

Solved!
Go to solution
Highlighted

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:

excel boxes.PNG

 

0 Kudos
Message 1 of 3
(549 Views)
Solution
Accepted by topic author ebohannon
03-09-2018 08:59 AM

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

urgent.PNG

Then follow this code to edit the text box:

shape.PNG

aputman
LabVIEW 2017
LabVIEW Programming
Message 2 of 3
(537 Views)

That worked perfectly! Thank you so much!

0 Kudos
Message 3 of 3
(524 Views)