hi, i’m tried to get info form control in excel not active control (check or uncheck)
vba or c# or whatever else is fine
ps.
i’m using internal network, so can’t use other libraries
plz help me
hi, i’m tried to get info form control in excel not active control (check or uncheck)
vba or c# or whatever else is fine
ps.
i’m using internal network, so can’t use other libraries
plz help me
my process is
Simply receive excel with in form control checkboxes from the other person
and i need a checkbox info , check or uncheck without updating the original excel file
if possible can you share the excel or the data screenshot from the excel here?
i’m testing just add form control checkboxes on test excel file
and i found this code (xlsm format)
If (ActiveSheet.Shapes("Check Box 2").OLEFormat.Object.Value = 1) Then
Message = "True"
Else
Message = "False"
End If
MsgBox Message
and test is success, if checkbox 2 is unchecked msgbox(False) printed
close to what i want!
next step is how to apply on UiPath by using invoke code or invoke VBA
can u recommand for me?