option buttons in a form

[raw]

Hi

I am using a form with different groups of options buttons But when use use the Control source (in Prop) to link then to a sheet the buttons do not seem to work as well is there code that i can use with a command button that will send which option button i have selected to a cell on which option i have chosen??

Also how do you load the form with out any of the option selected ie no black dots in them until you select them (this stops people makeing errors with the selection)

Thanks for your help

 

[Tazguy37]

Also how do you load the form with out any of the option selected ie no black dots in them until you select them (this stops people makeing errors with the selection)

Thanks for your help

Have you tried setting each optionbutton to False?