ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to enter a radio button on excel (https://www.excelbanter.com/excel-worksheet-functions/209483-how-enter-radio-button-excel.html)

Memo

how to enter a radio button on excel
 
i am running ecel 2003 and need to add a radio button on a spreadsheet that i
am creating so people have an option to click on a cell to indicate the task
has been completed. any help is greatly appreciated.

ShaneDevenshire

how to enter a radio button on excel
 
Hi,

You can add a radio button either by using the Forms toolbar or the Control
Toolbox toolbar. Bothi have option (radio) buttons. To see them right click
any toolbar and display either one.


--
Thanks,
Shane Devenshire


"Memo" wrote:

i am running ecel 2003 and need to add a radio button on a spreadsheet that i
am creating so people have an option to click on a cell to indicate the task
has been completed. any help is greatly appreciated.


Satti Charvak

how to enter a radio button on excel
 
Also Memo,

You can trap the value of the radio button.

Right Click - Format Control

Goto control Tab and in the cell link, give the cell location where you want
the result.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"ShaneDevenshire" wrote:

Hi,

You can add a radio button either by using the Forms toolbar or the Control
Toolbox toolbar. Bothi have option (radio) buttons. To see them right click
any toolbar and display either one.


--
Thanks,
Shane Devenshire


"Memo" wrote:

i am running ecel 2003 and need to add a radio button on a spreadsheet that i
am creating so people have an option to click on a cell to indicate the task
has been completed. any help is greatly appreciated.



All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com