I’m trying to have a macro interact with form controls and cells on a document.
Basically I want a button to uncheck several checkboxes when clicked (among other things) .
Problem is I don’t know how to get access to the checkboxes in the macro editor.
Dim Dlg As Object
Dlg = CreateUnoDialog(DialogLibraries.Standard.Dialog1)
Except my checkboxes aren’t in this Dialog, they’re on a Sheet. And ThisComponent.getControl or ThisComponent.Sheet(0).getControl don’t work.
I’m doing this with a Basic guide pdf because I don’t really know the language, but I can’t figure the solution.