Check/option

G

gavmer

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!!!
 
G

gavmer

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!!!!!
 
Top