Help with Options Buttons

[smweasel]

Hi all!
I am trying to create a survey using 10 option buttons (high=10/low=1) for each question (6 questions). I want to average the score at the end but the option buttons are not exclusive to each question. How can I have my 10 option buttons and the selected value be exclusive to that question and the next 10 be exclusive to the next question, etc.
Any help would be fantastic as I have been searching for hours.
Thanks

 

[Domenic]

Try placing each set of option buttons in a frame...

 

[djreiswig]

Look at the GroupName property. Give each group of buttons a unique GroupName and each group will act separately.

 

[smweasel]

djreiswig-thanks for the reply
i tried the grouping and naming of the buttons but the cell link remains static when i go to the next question. i want to have each group be linked to a different cell so i can get a unique value for each question. is this possible without VBA?