Tri-State Checkbox in excel VBA
<p>I am developing a macro in Excel VBA and I am not expert. I need to show data in Treeview. In tree view there are only two state for checkbox. Either select or not select. I want to know is there any way(Preferably simple way) to show a third state.</p>

<p>Let say I have 10 children in a node, If user select checkbox for 5 children then parent node should display partial selection state of check box. </p>

<p>It is not needed to be a checkbox any control that show tristate would be fine.</p>

<p>Note: Before I came here I spent more than 5 hours in google. But I am not able find solution that match my need.</p>

<p>Any help will be appreciated.</p>