#1   Report Post  
Jonah
 
Posts: n/a
Default 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   Report Post  
Jason Morin
 
Posts: n/a
Default

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   Report Post  
Jonah
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I setup a cell in Excel as a checkbox w/o a form/activex c. Arno Rite Excel Discussion (Misc queries) 15 November 27th 06 08:50 PM
reading from chart Jim Excel Discussion (Misc queries) 2 December 29th 04 02:31 PM
resize control checkbox with cell packat Excel Discussion (Misc queries) 2 December 27th 04 01:16 PM
Checkbox not part of cell. (???) Cells can move "underneath". (!!!) Thomas G. Marshall Excel Discussion (Misc queries) 4 December 18th 04 04:15 PM
reading currency/number whitesnow Excel Discussion (Misc queries) 1 December 15th 04 09:43 AM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"