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.
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?
Bookmarks