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

    <P>if i have spread checkbox maybe cheched or unchecked i want to set the value (cheched or unchecked ) to microsoft check box</P>
    <P>i tried this but not work</P>
    <P>vb code</P>
    <P>checkbox1.checked = spread1.activesheet.cells(myrow,mycol).value</P>
    <P>thanks for help</P>
  • Replied 8 September 2017, 2:30 pm EST

    <p><font face="arial,helvetica,sans-serif" size="2">Hello,</font></p><p><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. <br></font></p>

    <blockquote><pre class="western" style="text-align:left;"><font face="arial,helvetica,sans-serif" size="2"><font color="#000000">Dim val As Boolean = CBool(fpSpread1.ActiveSheet.ActiveCell.Value)</font><br>checkBox1.Checked = val</font></pre></blockquote><pre class="western" style="text-align:left;"><font face="arial,helvetica,sans-serif" size="2">Hope this will help you. Thanks. </font><br></pre>
  • 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