How to get form control(checkbox) info in excel?

Help Something Else
,
1

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

2

Hi @rjsekaskfro

Welcome to Community!

Can you elaborate your task?

Regards
Sudharsan

3

hi @Sudharsan_Ka

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

4

if possible can you share the excel or the data screenshot from the excel here?

5

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?

6

Checkout this @rjsekaskfro

Regards
Sudharsan

7

sry
how can i conver to vb to vb.net ? ActiveSheet is not working vb.net?
code is

Sub Uncheckallcheckboxes()
If (ActiveSheet.Shapes(“Check Box 2”).OLEFormat.Object.Value = 1) Then
Message = “True”
Else
Message = “flse”
End If
MsgBox Message

End Sub