Hi all

I am hoping to us a check box or option button to select items in
list. When selected, i would like the linked cell to return the actua
value of the range it is linked to....rather than true/false.

IE

option 1 (Check box) - 2000 value the linked cell returns

option 2 (1000) - as above

option 3 (2500) - as above

Any ideas all????

Cheers!!!

--
Message posted from http://www.ExcelForum.com

Hi
why not use 'Data - Validation - List' for this. See:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany

"gavmer " schrieb im
Newsbeitrag ...
Hi all

I am hoping to us a check box or option button to select items in a
list. When selected, i would like the linked cell to return the
actual
value of the range it is linked to....rather than true/false.

IE

option 1 (Check box) - 2000 value the linked cell returns

option 2 (1000) - as above

option 3 (2500) - as above

Any ideas all????

Cheers!!!!


---
Message posted from http://www.ExcelForum.com/

Hi Frank,

thank you!!!! Will this suit as only 1 price is linked to each cell
Imagine 5 rows. In the 5 rows, there is one price relating to each.
user should use a check box, etc, to select if that option is require
and if so, the price would copy to column C next to the option.

Am i travelling down the wrong path?? There are about 100 options t
select from.

cheers!!!!!

--
Message posted from http://www.ExcelForum.com