copy data to worksheet from an OptionButton

hi,

ive been given a task at work that means ive had to add a form to an excel spread sheet.
its for logging enquires. its a really simple job.
at the moment ive got it working so it stores the values from some text fields [see code below] in a table.

Please Login or Register  to view this content.

i need to add some optionBoxes [and a drop down later] so they can choose between 'yes', 'no' and 'na'.
ive added the option buttons and grouped them. however i cant work out how to store the info like im doing with the text buttons.

i tried ws.Cells(iRow, 9).Value = Me.english.Value [where 'english' is the name of the group] but this didnt work.

does any one know the correct way to do this?

thanks but the syntax they use in your example is totally different to the one used in my example so i wont be able to use it. i dont know vb and i dont have the time to learn...
i need to do something like:

ws.Cells(iRow, 9).Value = Me.english.Value

where 'english' is the name of the group of radio buttons.

Moderators Note:

• Please follow Forum Rule #3 and use code tags.
• Added this time, but please use them in the future…Thanks.