selected option button assign 1 to a cell and others 0

i have a quick excel question that involves macro.

basically, what i need to do is this.

i have option buttons and when one out of three buttons is clicked, it
needs to put the value "1" in the cell right behind the selected
option button and "0" into each cell behind other option buttons.

do you have any suggestions for the macro?

much thanks in advance,

hyejin

There's a similar probelm with solutions outlined in the thread below.

http://www.excelforum.com/showthread...38012#poststop