Click to Reset Radio Button
 

I have a number of control groups on a worksheet with radio buttons in
them (looks like a scantron). Is there a way for a user to reset a
radio button by just clicking again on it without having to "right
click" and click on
"clear contents". I ask because I will be disabling all the command
bars and right click ability through VBA. It was suggested to me that
I add an N/A button or just convert to checkboxes, but I really want
to mimick the real test input for my students for simplicity. There
must be code out there somewhere to do this. Worksheet/form looks like
this:

1. ( ) A ( ) B ( ) C ( ) D
2. ( ) F ( ) G ( ) H ( ) J
3. ( ) A ( ) B ( ) C ( ) D
etc

Any help would be appreciated.

Click to Reset Radio Button
 

I apologize, please disregard. I already have a post going--I posted this in
google thinking it was a different forum. Discussion is currently he
http://www.microsoft.com/office/comm...7-234e01651037

"dgold82" wrote:

I have a number of control groups on a worksheet with radio buttons in
them (looks like a scantron). Is there a way for a user to reset a
radio button by just clicking again on it without having to "right
click" and click on
"clear contents". I ask because I will be disabling all the command
bars and right click ability through VBA. It was suggested to me that
I add an N/A button or just convert to checkboxes, but I really want
to mimick the real test input for my students for simplicity. There
must be code out there somewhere to do this. Worksheet/form looks like
this:

1. ( ) A ( ) B ( ) C ( ) D
2. ( ) F ( ) G ( ) H ( ) J
3. ( ) A ( ) B ( ) C ( ) D
etc

Any help would be appreciated.