Free Support Forum - aspose.com

Missing Reference in VBA

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.