Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I setup a cell in Excel as a checkbox w/o a form/activex c. | Excel Discussion (Misc queries) | |||
reading from chart | Excel Discussion (Misc queries) | |||
resize control checkbox with cell | Excel Discussion (Misc queries) | |||
Checkbox not part of cell. (???) Cells can move "underneath". (!!!) | Excel Discussion (Misc queries) | |||
reading currency/number | Excel Discussion (Misc queries) |