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

    <font face="arial,helvetica,sans-serif" size="2">Hello,</font>

    <font face="arial,helvetica,sans-serif" size="2">Win forms checkbox's checked property take bool value, hence you need to convert spread's cell value to bool.

    <font face="arial,helvetica,sans-serif" size="2"><font color="#000000">Dim val As Boolean = CBool(fpSpread1.ActiveSheet.ActiveCell.Value)</font>
    checkBox1.Checked = val</font>
    <font face="arial,helvetica,sans-serif" size="2">Hope this will help you. Thanks. </font>

  • 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