You go to View - Toolbars - Forms & select it to view form toolbar. From this toolbar select the control you want. Now link this control to a cell using format control by right clicking the control. Now use this linked cell in your formula, having answer 'True or False'. By trial & Error you will know how to use it. I used this trick with check boxes on my worksheet.
rajan deshpande
Matthew Dyer wrote:
adding check boxes into an excel workbook
08-Nov-09
How do I go about adding things like radio buttons and check boxe
into a worksheet? Am I forced to use a form?
You go to View - Toolbars - Forms & select it to view form toolbar. From this toolbar select the control you want. Now link this control to a cell using format control by right clicking the control. Now use this linked cell in your formula, having answer 'True or False'. By trial & Error you will know how to use it. I used this trick with check boxes on my worksheet.
rajan deshpande
Matthew Dyer wrote:
adding check boxes into an excel workbook
08-Nov-09
How do I go about adding things like radio buttons and check boxe
into a worksheet? Am I forced to use a form?
