how to get the value of spread checkbox and set to microsoft checkbox

Posted by: redahashem-fp on 8 September 2017, 2:30 pm EST

  • Posted 8 September 2017, 2:30 pm EST

    if i have spread checkbox maybe cheched or unchecked i want to set the value (cheched or unchecked ) to microsoft check box


    i tried this but not work


    vb code


    ===========


    checkbox1.checked = spread1.activesheet.cells(myrow,mycol).value


    thanks for help

  • Replied 8 September 2017, 2:30 pm EST

    Hello,

    Win forms checkbox's checked property take bool value, hence you need to convert spread's cell value to bool.











    Dim val As Boolean = CBool(fpSpread1.ActiveSheet.ActiveCell.Value)
    checkBox1.Checked = val
    Hope this will help you. Thanks. 


     
  • Replied 8 September 2017, 2:30 pm EST

    thank you so much it works
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels