Ok, I have a really stupid question. But since I lack
programming skills and have the patients of a 4 year old
today, I am going to ask the question.

I need to set up a option box where the user
selects "Gold" "Silver" or "Bronze". When the user
selects the option, I need a certain cell to Change to
that name. I have linked to this cell which drives other
formulas. I have the option buttons setup, but cannot get
the code to set a certain cell to the particular
selection. Thanks in advance for any help!