Hi !
After creating runtime Checkbox in excel sheet, I am not getting any reference in VB editor (Macro).
What I have to do to get reference in VB Editor.
Thank You.
Hi !
After creating runtime Checkbox in excel sheet, I am not getting any reference in VB editor (Macro).
What I have to do to get reference in VB Editor.
Thank You.
Hi,
Thanks for considering Aspose.
Do you mean to say that you want to access/manipulate vba macros for the checkbox using Aspose.Cells APIs. I am not very clear about your need, could you give us some more details about your requirment and how are you doing. And if you create a checkbox in MS Excel manually, did you get its object reference in vb editor (using menu i.e., Options | Macro| Visual Basic Editor) and how? I am not much familiar with vba code either. For your info, Aspose.Cells does not support to create/ manipulate vba / macros, it can only preserve vba code / macros in the template file when opening with it and save the file with the vba code / macros attached.
Thank you.
Actually I am trying to do following code.
'''''Code'''''''''
Dim oActivityCheckBox As OLEObject
Dim poWorkSheet As Excel.Worksheet
''Some Coding to activate Worksheet
For Each oActivityCheckBox In poWorkSheet.OLEObjects
''Some Lines
Next
'''''End'''
I have some checkboxes on sheet but when I debug, it doesn't go in For..Next Loop.