Hi,
I would use radio buttons, you can group them together by putting a
group box around them and each button within a group has it's own value
and is linked to the same cell. Reserve a column to link to...say A,
then to pull the value amount corresponding to the radio button
selected with:
=LOOKUP(A1,{1,2},{5,10})
{1,2} are the button values
{5,10} are the corresponding values...in your case $5 and 10$
Note. you can not use $ in that formula.
HTH
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread:
http://www.excelforum.com/showthread...hreadid=498123