We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Find OLEObjects and assign value

Hi,

I need to convert excel macro code below , where i need to get the option radio buttons from excel. I need to assign value to radio button and make them visible.

Can you please advise how can this be achieved using Aspose.

ActiveSheet.OLEObjects("optMillions").Object.Enabled = True
ActiveSheet.OLEObjects("optMillions").Visible = True


This message was posted using Aspose.Live 2 Forum

Hi,

I am afraid, Aspose.Cells for .NET does not support event handling, so you cannot assign code segments to the events of the controls, although we do support to create or manipulate drawing objects and controls (including radio buttons), see the topic for complete reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/working-with-controls.html

And, if you simply need to create or manipulate(read and write) Ole Objects in the worksheets, you can do it, see the topic for your reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/managing-ole-objects.html

Thank you.