How can i use Microsoft.Office.Interop.Excel.XlTriState.xlOn

Feedback Other Products
, , ,
1

hi guys
i’m trying to whether checked or unchecked in excel form-control using vb.net
and i got the answer below code

checkboxControl = CType(xlWorksheet.CheckBoxes("CheckBox1"), Microsoft.Office.Interop.Excel.CheckBox)

If checkboxControl.Value = Microsoft.Office.Interop.Excel.XlTriState.xlOn Then

but i can’t find Microsoft.Office.Interop.Excel.XlTriState.xlOn << maybe PIA(Primary Interop Assemblies…) how can i use this??

2

Hi @rjsekaskfro ,

Could you let us know how have you used the code in the workflow ?

3

is my question, it just used invoke-code
thanks

4

i solved thanks

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.