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!

In Office 2K, right click on the option button and choose Format control.
Click on the Control tab and enter the linked cell in the option there.

HTH, Greg

"Craig" wrote in message
...
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!