Use a userform, with radio (option) buttons on frames- one frame per question, 4 option buttons per
frame. Use the click event of the option button to set the value in an appropriate cell.

HTH,
Bernie
MS Excel MVP


"dgold82" wrote in message
...
I am trying to make a worksheet that mimicks a scantron on a standardized
test. I would like to have bubbles with letters in them and when a bubble is
clicked it sends that letter to a regular cell. so it would look something
like this: (a) (b) (c) (d) for question #1. When (a) is clicked it sends the
"A" to a cell on a seperate sheet for calculation purposes.