ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Checkbox reading (https://www.excelbanter.com/excel-worksheet-functions/6812-checkbox-reading.html)

Jonah

Checkbox reading
 
Can I read a checkbox's content to a cell? Ideas please.

Can a checkbox be made to include a variable such as a letter A or a B
or a C and nothing else or is this only possibel in a cell?

Jonah


Jason Morin

With checkboxes from the Control Toolbox, you can set the
LinkedCell property to a cell reference. If the checkbox
is clicked, the cell will return TRUE. To set it, go into
design mode, right-click on the checkbox, and go into
Properties.

HTH
Jason
Atlanta, GA

-----Original Message-----
Can I read a checkbox's content to a cell? Ideas please.

Can a checkbox be made to include a variable such as a

letter A or a B
or a C and nothing else or is this only possibel in a

cell?

Jonah

.


Jonah

Thankyou for that. At least there is some hope of a solution even if it
is a partial one. I was hoping that a numeric variable might be a
solution, but am really looking for a triple choice variable. A sort of
drop down on three letters such as an A or a B or a C. Any ideas?

Jonah
------------

Jason Morin wrote:

With checkboxes from the Control Toolbox, you can set the
LinkedCell property to a cell reference. If the checkbox
is clicked, the cell will return TRUE. To set it, go into
design mode, right-click on the checkbox, and go into
Properties.

HTH
Jason
Atlanta, GA

-----Original Message-----
Can I read a checkbox's content to a cell? Ideas please.

Can a checkbox be made to include a variable such as a

letter A or a B
or a C and nothing else or is this only possibel in a

cell?

Jonah

.




All times are GMT +1. The time now is 02:18 PM.

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