Thanks. Just what I was looking for.


"Debra Dalgleish" wrote in message
...
If you used option buttons from the Forms toolbar, you can link them to
a cell --
Right-click on the option button
Choose Format Control
Select the Control tab
Click in the Cell Link box, and then click on a worksheet cell,
e.g. $C$1

Set up a table with the values and options, e.g.

100 Blue Red
200 Purple Green

In cell A2, enter a formula that looks up the applicable value:

=VLOOKUP(A1,I2:K3,C1+1,0)

where the lookup table is in cell I2:K3

D. Miller wrote:
I'm not sure if this is possible or not, but I would like to use two
option
buttons to determine the contents of a cell, which is dependent on the
value
of another cell. As an example, if I insert 100 in cell A1, cell A2
would
display "Blue" if option button 1 is selected. However, if option button
2
is selected, then cell A2 would display "Red", (100 would still be in
cell
A1). If I insert 200 in cell A1, then cell A2 would display "Purple"
with
option button 1 selected or "Green" with option button 2 selected. Cell
A2
would be able to return two different values of whatever was in cell A1,
depending on which option button was clicked. Any help with this would
be
greatly appreciated. Thanks in advance.

D. Miller




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html