adding check boxes into an excel workbook

[Matthew Dyer]

How do I go about adding things like radio buttons and check boxes
into a worksheet? Am I forced to use a form?

 

[rajan deshpande]

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?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
JavaScript Bar Graph Control
http://www.eggheadcafe.com/tutorial...f-57bba826f2a3/javascript-bar-graph-cont.aspx

 

[rajan deshpande]

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?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
..NET GDI+ - Convert BitMap To Jpeg
http://www.eggheadcafe.com/tutorial...accd-8291f3c89dfe/net-gdi--convert-bitma.aspx